QUERY: SELECT a.titre, a.description, r.id AS redac_id, a.id AS article_id, r.util_id FROM redactionnels r INNER JOIN articles a ON r.art_id=a.id INNER JOIN parution p ON p.objet_id=r.id AND r.type_objet=p.type_objet WHERE r.status=1 AND r.dossier_id=38 ORDER BY RAND() LIMIT 3
Choisir son énergie de chauffage: Equipements énergies renouvelables

Choisir son énergie de chauffage

QUERY: SELECT a.titre, a.description, r.id AS redac_id, a.id AS article_id, r.util_id FROM redactionnels r INNER JOIN articles a ON r.art_id=a.id INNER JOIN parution p ON p.objet_id=r.id AND r.type_objet=p.type_objet INNER JOIN parution_dates pd ON pd.parution_id=p.id WHERE r.status=1 AND NOW() BETWEEN pd.date_debut AND pd.date_fin ORDER BY RAND() LIMIT 3

A lire également