1525: Incorrect DATE value: '0000-00-00'
select t.ET_HEADING AS HEADING, t.ET_LEAD AS `LEAD`,ET_BODY AS CONTENT,DATE_FORMAT(t.TEXTDATE,'%d.%m.%Y') AS DATE, se.ID AS SID
from texts t
INNER join structure se on se.ID=t.STR_PLACE
where t.ACTIVE=1 AND t.NEWS=1 AND TEXTDATE<='2025-03-31' AND (EDATE>='2025-03-31' OR EDATE='0000-00-00')
ORDER BY t.TEXTDATE DESC
Uudised - Loodusheli