SELECT *
FROM fon_publications
INNER JOIN languages ON fon_publications.id_langue = languages.id_langue
LEFT OUTER JOIN lieux ON fon_publications.id_lieu = lieux.id_lieu
WHERE fon_publications.statut = 2
ORDER BY fon_publications.annee ASC, fon_publications.id_publication DESC
