Incorrect DATE value: '0000-00-00' SELECT pc_eid AS "eid",pc_aid AS "aid",pc_title AS "title",pc_time AS "time",pc_hometext AS "hometext",pc_informant AS "informant",pc_eventDate AS "eventDate",pc_duration AS "duration",pc_endDate AS "endDate",pc_recurrtype AS "recurrtype",pc_recurrspec AS "recurrspec",pc_startTime AS "startTime",pc_alldayevent AS "alldayevent",pc_location AS "location",pc_conttel AS "conttel",pc_contname AS "contname",pc_contemail AS "contemail",pc_website AS "website",pc_fee AS "fee",pc_eventstatus AS "eventstatus",pc_sharing AS "sharing",pc_hooked_modulename AS "hooked_modulename",pc_hooked_objectid AS "hooked_objectid",pc_obj_status AS "obj_status",pc_cr_date AS "cr_date",pc_cr_uid AS "cr_uid",pc_lu_date AS "lu_date",pc_lu_uid AS "lu_uid" FROM nuke_postcalendar_events AS tbl WHERE pc_eventstatus=1
AND (pc_endDate>='2019-07-22'
OR (pc_endDate='0000-00-00' AND pc_recurrtype<>'0')
OR pc_eventDate>='2019-07-22')
AND pc_eventDate<='2019-07-22' AND (pc_sharing = '3' OR pc_sharing = '1') Catamaran Sailboats at TheBeachcats.com
Incorrect DATE value: '0000-00-00' SELECT pc_eid AS "eid",pc_aid AS "aid",pc_title AS "title",pc_time AS "time",pc_hometext AS "hometext",pc_informant AS "informant",pc_eventDate AS "eventDate",pc_duration AS "duration",pc_endDate AS "endDate",pc_recurrtype AS "recurrtype",pc_recurrspec AS "recurrspec",pc_startTime AS "startTime",pc_alldayevent AS "alldayevent",pc_location AS "location",pc_conttel AS "conttel",pc_contname AS "contname",pc_contemail AS "contemail",pc_website AS "website",pc_fee AS "fee",pc_eventstatus AS "eventstatus",pc_sharing AS "sharing",pc_hooked_modulename AS "hooked_modulename",pc_hooked_objectid AS "hooked_objectid",pc_obj_status AS "obj_status",pc_cr_date AS "cr_date",pc_cr_uid AS "cr_uid",pc_lu_date AS "lu_date",pc_lu_uid AS "lu_uid" FROM nuke_postcalendar_events AS tbl WHERE pc_eventstatus=1
AND (pc_endDate>='2023-11-26'
OR (pc_endDate='0000-00-00' AND pc_recurrtype<>'0')
OR pc_eventDate>='2023-11-26')
AND pc_eventDate<='2025-12-31' AND (pc_sharing = '3' OR pc_sharing = '1')