Schedule List View

WordPress database error: [Incorrect TIMESTAMP value: '']
SELECT GROUP_CONCAT(td.type_name) as types, a.attendee_count, a.purge_check, e.reg_limit-IFNULL(sum(a.attendee_count),0)=0 as is_waitlist,e.event_name as event_name, e.event_desc, e.start_date as start_date, e.end_date as end_date, s.start_time as start_time, s.end_time as end_time, e.early_disc, e.early_disc_date, e.early_disc_percentage, e.id as id, e.allow_multiple, e.additional_limit, e.event_meta, e.registration_start, e.registration_startT, e.registration_end, e.registration_endT, e.reg_limit, e.overflow_event_id, e.allow_overflow, SUBSTR(event_meta, INSTR(event_meta, 'quarter')+14, INSTR(SUBSTR(event_meta, INSTR(event_meta, 'quarter')+14), '"')-1) as qtr, SUBSTR(event_meta, INSTR(event_meta, 'quarter')+14, 1) as firstqtr, SUBSTR(event_meta, INSTR(event_meta, 'grade_range')+18, INSTR(SUBSTR(event_meta, INSTR(event_meta, 'grade_range')+18), '"')-1) as grade, p.event_cost, p.id as price_id, r.cat_id FROM wp_events_detail e JOIN wp_events_prices p ON p.event_id=e.id JOIN wp_events_category_rel r ON r.event_id = e.id JOIN wp_events_start_end s ON s.event_id = e.id LEFT JOIN wp_events_type_rel as tr ON tr.event_id = e.id LEFT JOIN wp_events_type_detail td ON tr.type_id = td.id LEFT JOIN (SELECT sum(quantity) as attendee_count, count(id) as purge_check, event_id from wp_events_attendee where date >= '' group by event_id) a ON a.event_id = e.id WHERE e.is_active = 'Y' AND e.id NOT IN (select distinct event_id from wp_events_category_rel where cat_id IN (20)) AND e.event_status = 'A' AND e.registration_start <= ADDDATE('2025-08-07', INTERVAL 30 DAY) AND e.start_date >= '' GROUP BY e.id ORDER BY s.start_time, e.event_name, date(e.start_date) ASC