SELECT articles.id_trad, articles.id_article, articles.date, articles.titre, articles.lang
FROM spip_articles AS `articles`
WHERE (articles.statut = 'publie')
	AND (articles.date < '2138-01-01 00:00:00')
	AND (articles.id_trad = 0)
	AND (1 = 1)
	AND (articles.id_rubrique = 26)
GROUP BY articles.id_article
ORDER BY articles.date DESC