Replicas browser and optimizer
List of uploaders for WLM-IT 2015
This query is marked as a draft
This query has been published
Full list of the user IDs who uploaded a file which was categorised in https://commons.wikimedia.org/wiki/Category:Uploaded_via_Campaign:wlm-it during September 2016 and uploaded in September 2016.
USE commonswiki_p; SELECT distinct(log_user) -- Replace with log_user_text for usernames FROM logging WHERE log_action = 'upload' AND log_timestamp BETWEEN '20160900' AND '20161000' AND log_page IN ( SELECT cl_from FROM categorylinks WHERE cl_to = 'Uploaded_via_Campaign:wlm-it' AND cl_timestamp BETWEEN '20150600' AND '20161000' );
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in