Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Jean-Frédéric
.
List of files supported by Wikimédia France and identified as Valued Images during the Q3 of FDC year 2013-2014 round2
Toggle Highlighting
SQL
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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...