WordPress database error: [Incorrect DATE value: '0000-00-00']
SELECT *, DATE_FORMAT(event_start_date, '%e') AS 'event_day', DATE_FORMAT(event_start_date, '%Y') AS 'event_year', DATE_FORMAT(event_start_time, '%k') AS 'event_hh', DATE_FORMAT(event_start_time, '%i') AS 'event_mm', DATE_FORMAT(event_end_date, '%e') AS 'event_end_day', DATE_FORMAT(event_end_date, '%Y') AS 'event_end_year', DATE_FORMAT(event_end_time, '%k') AS 'event_end_hh', DATE_FORMAT(event_end_time, '%i') AS 'event_end_mm' FROM wp_dbem_events WHERE event_status=1 AND (event_start_date >= '2024-05-02' OR (event_end_date >= '2024-05-02' AND event_end_date != '0000-00-00' AND event_end_date IS NOT NULL)) ORDER BY event_start_date ASC , event_start_time ASC LIMIT 11