T16 SELECT c.id, c.titre, '' AS chapo, c.date_affichage, cit.DESCRIPTION AS rubriques
FROM production_internet.contenu AS c
LEFT JOIN
contenu_theme ct ON ( c.id = ct.id_contenu )
INNER JOIN
contenu.indexation_thematique cit ON (ct.id_theme = cit.ID_THEME)
WHERE c.id_contenu IN ( 5, 12 )
AND ct.id_theme IN ( 'id6350', 'id3243', 'id3244' )
ORDER BY date_affichage DESC limit :start, :length
Dépêches - AG COMPTA CONSEILS
T16 SELECT c.id, c.titre, '' AS chapo, c.date_affichage, cit.DESCRIPTION AS rubriques
FROM production_internet.contenu AS c
LEFT JOIN
contenu_theme ct ON ( c.id = ct.id_contenu )
INNER JOIN
contenu.indexation_thematique cit ON (ct.id_theme = cit.ID_THEME)
WHERE c.id_contenu IN ( 5, 12 )
AND ct.id_theme IN ( 'id6350', 'id3243', 'id3244' )
and c.date_affichage BETWEEN :date AND DATE_ADD( :date, INTERVAL 1 MONTH ) ORDER BY date_affichage DESC limit :start, :length
