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 `jos_dpcalendar_events` AS a
LEFT JOIN jos_categories AS c ON c.id = a.catid
LEFT JOIN jos_dpcalendar_events_location AS rel ON a.id = rel.event_id
LEFT JOIN jos_dpcalendar_locations AS v ON rel.location_id = v.id
LEFT JOIN jos_users AS ua ON ua.id = a.created_by
LEFT JOIN jos_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 (20) 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-04-05 12:12:19') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-05 12:12:19') AND (a.start_date  >= '-0001-11-30 00:00:00')
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