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'