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 = '2020-11-3' 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'