Error!

MySQL Error: Incorrect DATE value: '11692/1/1'
SQL Statement: select count(*) as total_records from (SELECT 1 FROM contents JOIN content_types on contents.content_type_id = content_types.id join events on contents.id= events.id WHERE content_type_id IN ('2542') and contents.published=1 and publish_date <= '2024-11-02 09:53' and date(publish_date) >= '11692/1/1' and date(publish_date) < '11693/1/1' and contents.magazine_id=7 ORDER BY events.start_date DESC ) as t