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,
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,
IFNULL( d.nom_fichier_encode, false ) AS image,
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 ( 94 ) AND
p.id_gabarit IN ( 134 , 165 , 202 ) AND
p.actif = 1 AND
p.id_page_statut = 4
GROUP BY p.id_page
ORDER BY
p.date_publication DESC,
p.id_page DESC
LIMIT 0,15
L'actualité immobilière à Toulouse | IMMO9Actualités
Actualités