SELECT page_title, img_user_text FROM image INNER JOIN (
SELECT page_title FROM page INNER JOIN (
SELECT page_id FROM templatelinks INNER JOIN (
SELECT /* SLOW_OK */ cl.cl_from as page_id
FROM categorylinks AS cl
WHERE cl.cl_to="All_medias_supported_by_Wikimedia_France"
) tmp ON tmp.page_id = templatelinks.tl_from
WHERE templatelinks.tl_namespace = 10 AND templatelinks.tl_title = "Quality_image"
) tmp2 ON page.page_id = tmp2.page_id
) tmp3 ON image.img_name = tmp3.page_title
WHERE image.img_timestamp BETWEEN 20120101000000 AND 20130101000000
ORDER BY img_timestamp ASC;
_-_005.jpg)
_d%C3%A9tour%C3%A9e.jpg)
