SQL
AخA
use commonswiki_p;
SELECT page_title, img_user_text AS uploader
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="Media_supported_by_Wikimedia_France"
AND cl2.cl_to="Valued_images_sorted_by_promotion_date"
AND img_timestamp BETWEEN 20150101000000 AND 20150401000000
ORDER BY uploader DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.