SELECT p.id_page, p.slug AS slug, p.id_page_parent, p.id_domaine, p.id_gabarit, p.id_page_statut, UNIX_TIMESTAMP(p.date_publication) AS date_publication, IF( p.date_maj, UNIX_TIMESTAMP(p.date_maj),UNIX_TIMESTAMP(p.date_publication)) AS date_modification, p.date_creation, p.date_maj, p.meta_title, p.meta_description, mc.nom AS motclef, p.titre_fil_ariane, p.titre, p.resume, p.texte, p.actif, IF( a.id_auteur IS NULL , 'inconnu' , CONCAT( a.prenom , ' ' , a.nom ) ) AS auteur, a.titre AS auteur_titre, a.lien_linkedin AS auteur_linkedin, IFNULL( d.nom_fichier_encode, false ) AS image, d.description AS image_caption, d.credits, pa.slug AS parent FROM pages p LEFT JOIN pages pa ON pa.id_page = p.id_page_parent LEFT JOIN liens_auteurs_objets lao ON lao.id_objet_lie = p.id_page AND lao.id_type_objet_lie = 18 LEFT JOIN auteurs a ON a.id_auteur = lao.id_auteur LEFT JOIN liens_documents_objets AS ldo ON ldo.id_document_role IN (22) AND ldo.id_type_objet_lie = 18 AND ldo.id_objet_lie = p.id_page LEFT JOIN liens_motclefs_objets lmo ON lmo.id_objet_lie = p.id_page AND lmo.id_type_objet_lie = 18 LEFT JOIN motclefs mc ON mc.id_motclef = lmo.id_motclef LEFT JOIN documents d ON d.id_document = ldo.id_document AND d.actif = 1 WHERE p.id_domaine IN ( 95 ) AND p.id_gabarit IN ( 134 , 165 , 202 ) AND p.slug = 'label-batiment-frugal' AND p.actif = 1 GROUP BY p.id_page