Incorrect DATE value: '14-24%20May 00:00:00'select event.*, asset.image as event_image, DATE(event.start_datetime) as murks, project.type_id as project_type_id, event_type.name as type_name ,group_concat(theme_to_content.theme_id separator ',') as themes ,group_concat(DISTINCT event_to_agegroup.agegroup_id separator ',') as agegroups ,group_concat(DISTINCT event_to_yeargroup.yeargroup_id separator ',') as yeargroups ,group_concat(DISTINCT coe_to_event.coe_id separator ',') as coes ,group_concat(DISTINCT booking.id separator ',') as bookings ,min(agegroup.id) as minage from event left join project on project.id=event.project_id left join theme_to_content on theme_to_content.content_id=event.id and theme_to_content.table_name='event' left join asset_to_content on asset_to_content.content_id=event.id and asset_to_content.table_name='event' and asset_to_content.my_order=0 left join asset on asset_to_content.asset_id=asset.id and asset.type='image' and asset.status=1 left join event_to_agegroup on event_to_agegroup.event_id=event.id left join agegroup on agegroup.id=event_to_agegroup.agegroup_id left join event_to_yeargroup on event_to_yeargroup.event_id=event.id left join coe_to_event on coe_to_event.event_id=event.id join booking on booking.event_id=event.id and booking.status=1 join performance on performance.booking_id=booking.id and performance.status=1 and ((DATE(performance.datetime) between '14-24%20May 00:00:00' and '14-24%20May 23:59:59') or (DATE(performance.datetime)<='14-24%20May 00:00:00' and DATE_ADD(performance.datetime, INTERVAL performance.duration MINUTE)>='14-24%20May 00:00:00')) left join event_type on event_type.id=event.type_id where 1=1 and event.status>=0 and event.type_id='1' and event.project_id='171' and DATE('14-24%20May') between DATE(event.start_datetime) and DATE(event.end_datetime) group by event.id order by minage asc