SELECT
a.*,
ad.article_data_id,
ad.lang,
ad.title,
ad.body,
ad.seo_title,
ad.seo_body,
ad.tag,
ad.handle,
u.*
FROM
article a
LEFT JOIN
article_data ad ON a.article_id = ad.article_id
LEFT JOIN user u USING(user_id)
LEFT JOIN f2a ON a.article_id = f2a.article_id
WHERE
parent_id = 165028 AND title = 'présentation'
GROUP BY a.article_id
ORDER BY rec_order ASC
SELECT
a.*,
ad.article_data_id,
ad.lang,
ad.title,
ad.body,
ad.seo_title,
ad.seo_body,
ad.tag,
ad.handle,
u.*
FROM
article a
LEFT JOIN
article_data ad ON a.article_id = ad.article_id
LEFT JOIN user u USING(user_id)
LEFT JOIN f2a ON a.article_id = f2a.article_id
WHERE
parent_id = 165063 AND mime LIKE 'image/%' AND f2a_id IS NOT NULL
GROUP BY a.article_id
ORDER BY date_start DESC
Académie
des Sciences Morales
des Lettres et des Arts de
Versailles
et d'Île-de-France
Fondation Édouard et Patrice Bonnefous