Incorrect DATETIME value: '-0001-11-30 00:00:00' SQL=SELECT a.*,c.title AS category_title,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
FROM `s2014_dpcalendar_events` AS a
LEFT JOIN s2014_categories AS c ON c.id = a.catid
LEFT JOIN s2014_dpcalendar_events_location AS rel ON a.id = rel.event_id
LEFT JOIN s2014_dpcalendar_locations AS v ON rel.location_id = v.id
LEFT JOIN s2014_users AS ua ON ua.id = a.created_by
LEFT JOIN s2014_users AS uam ON uam.id = a.modified_by
WHERE a.access IN (1,1,5) AND (a.original_id in (-1, 0) or (a.original_id > 0 and a.modified > '0000-00-00 00:00:00')) AND a.catid IN (78) AND c.access IN (1,1,5) AND a.state = 1 AND a.state != -2 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-03-13 22:46:55') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-03-13 22:46:55') AND (a.start_date  >= '-0001-11-30 00:00:00') AND a.language in ('en-GB','*')
GROUP BY a.id
ORDER BY start_date ASC LIMIT 0, 100000BEGIN:VCALENDAR
VERSION:2.0
PRODID:DPCALENDAR
CALSCALE:GREGORIAN
X-WR-TIMEZONE:UTC
END:VCALENDAR