SELECT articles.titre, articles.lang FROM `mabase`.spip_articles AS `articles` INNER JOIN `mabase`.spip_mots_rubriques AS L1 ON ( L1.id_rubrique = articles.id_rubrique ) WHERE (articles.statut = 'publie') AND (articles.date < '9999-12-31') AND (L1.id_mot = 15) GROUP BY articles.id_article ORDER BY articles.titre