Error Number: 1525

Incorrect DATE value: '0000-00-00'

SELECT n.id, n.title, n.translit_name, n.fullnews, n.date, n.time, n.category FROM news AS n JOIN pages AS p ON p.id = n.category WHERE (p.id IN (27, 79) OR p.id IN (SELECT id FROM pages WHERE parent IN (27, 79))) AND n.available = 1 AND n.is_delete = 0 AND n.date <= '2022-08-08' AND n.date != '0000-00-00' ORDER BY n.date DESC, n.time DESC LIMIT 30