Error!

MySQL Error: Incorrect DATE value: '23715/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 events.start_date >='2024-04-18' and content_type_id IN ('2539') and contents.published=1 and publish_date <= '2024-04-18 19:19' and date(publish_date) >= '23715/1/1' and date(publish_date) < '23716/1/1' and contents.magazine_id=10 ORDER BY events.start_date ASC ) as t