User:Jean-Frédéric/WmFr/2012/QI
SELECT /* SLOW_OK */ image.img_name, img_user_text
FROM page
JOIN categorylinks AS cl1 ON page_id=cl1.cl_from
JOIN categorylinks AS cl2 ON page_id=cl2.cl_from
JOIN image ON image.img_name = page.page_title
WHERE cl1.cl_to="All_medias_supported_by_Wikimedia_France"
AND cl2.cl_to="Quality_images"
AND img_timestamp BETWEEN 20120101000000 AND 20130101000000
ORDER BY img_timestamp ASC;