Incorrect DATETIME value: '' SQL=SELECT DISTINCT field_2, a.id FROM jos_gmapfp as a LEFT OUTER JOIN jos_categories AS c on a.catid = c.id WHERE a.published = 1 AND c.published = 1 AND (a.access IN (1,1,5) or (a.access = "")) AND (c.access IN (1,1,5) or (c.access = "")) AND ( a.publish_up = '' OR a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 14:00:49' ) AND ( a.publish_down = '' OR a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 14:00:49' ) GROUP BY field_2