SELECT
					cal_calendar.id,
					cal_calendar.event_date,
					calendar.event_time,
					DATE_FORMAT(cal_calendar.event_time, '%H:%i') as event_time_formatted,					
					cal_events.name,
					cal_events.description,
					cal_events_categories.color
				FROM cal_calendar
					INNER JOIN cal_events ON cal_calendar.event_id = cal_events.id
					LEFT OUTER JOIN cal_events_categories ON cal_events.category_id = cal_events_categories.id
				WHERE
					cal_calendar.event_date = '2024-11-6'
					 AND (SUBSTRING(cal_calendar.event_time, 4, 2) = '00' OR SUBSTRING(cal_calendar.event_time, 4, 2) = '30') 
					
				ORDER BY cal_calendar.event_date DESC, cal_events.name|Unknown column 'calendar.event_time' in 'field list'