Юлия Фрейд психолог - Расписание Курсов, Вебинаров

SELECT GROUP_CONCAT(CONCAT("", apcal_events.name, "") ORDER BY apcal_calendar.event_time ASC SEPARATOR "$$") as cnt, apcal_calendar.event_date, GROUP_CONCAT(CONCAT(apcal_events.id, "===", apcal_events.description) ORDER BY apcal_calendar.event_time ASC SEPARATOR "$$") as id_description, SUBSTRING(apcal_calendar.event_date, 9, 2) as day FROM apcal_calendar INNER JOIN apcal_events ON apcal_calendar.event_id = apcal_events.id WHERE SUBSTRING(apcal_calendar.event_date, 1, 4) = '2024' AND SUBSTRING(apcal_calendar.event_date, 6, 2) = '09' AND SUBSTRING(apcal_calendar.event_time, 4, 2) = '00' AND SUBSTRING(apcal_calendar.event_time, 1, 2) >= '10' AND SUBSTRING(apcal_calendar.event_time, 1, 2) < '18' GROUP BY SUBSTRING(apcal_calendar.event_date, 9, 2), apcal_calendar.event_date|Table 'cc74611_calendar.apcal_calendar' doesn't exist