L'actualité des tournois

SELECT SQL_CALC_FOUND_ROWS a.id, a.titre, a.photo, a.pubdate, a.meta_url, a.meta_description, at.idGroup_theme, at.id_spec FROM articles a INNER JOIN articles_thematiques at ON a.idGroup = at.idGroup_article AND at.idGroup_theme!='15' WHERE a.LCID='1036' AND a.etat=1 AND a.visible=1 AND (pubdateend='0000-00-00 00:00:00' OR pubdateend>NOW()) AND at.idGroup_theme='12' AND at.id_spec='7' GROUP BY a.id ORDER BY pubdate DESC LIMIT 0,10
Incorrect DATETIME value: '0000-00-00 00:00:00'