Incorrect DATETIME value: '2020-06-31 00:00:00'select events.*, event_types.name as type_name, group_concat(distinct events_to_spaces.space_id separator ', ') as spaces, group_concat(distinct spaces.name separator ', ') as space_names, group_concat(distinct event_category.name separator ' ') as category_names from events left join event_types on event_types.id=events.type_id left join events_to_spaces on events_to_spaces.event_id=events.id left join spaces on events_to_spaces.space_id = spaces.id join event_to_category on event_to_category.event_id = events.id and event_to_category.category_id = '2' left join event_category on event_category.id = event_to_category.category_id where events.status=1 and ((events.start_datetime < '2020-06-31 00:00:00' AND end_datetime > '2020-06-31 23:59:59') OR (start_datetime>='2020-06-31 00:00:00' AND start_datetime<='2020-06-31 23:59:59') OR (end_datetime>='2020-06-31' AND end_datetime<='2020-06-31 23:59:59')) and events.featured='1' and events.is_touring='0' group by events.id order by events.start_datetime desc limit 1000