SELECT * FROM METACONNEXION INNER JOIN NEWS ON METACONNEXION.element = NEWS.id WHERE (METACONNEXION.id > 0 AND METACONNEXION.parent = 18 AND METACONNEXION.classe_parent = "label" AND classe_element = "news" AND METACONNEXION.classe_lien = "parent" AND (METACONNEXION.date BETWEEN 20220400 AND 20220431)) ORDER BY NEWS.date DESC, NEWS.heure DESC, NEWS.id DESC Maitres du Monde
Maitres du Monde 
