Some recent Commons uploads by new uploaders

This query is marked as a draft This query has been published by Jmorgan (WMF).

Last run March 27 2018
Uploads using UploadWizard from between March 15th and March 19th

SQL

use commonswiki_p;

select CONCAT("https://commons.wikimedia.org/wiki/File:", rc_title) AS img_url, rc_user_text, rc_timestamp 
from recentchanges as r JOIN user as u on r.rc_user = u.user_id where 
r.rc_namespace = 6 and
r.rc_log_action = "upload" and
rc_timestamp between 20180315000000 and 20180320000000
and u.user_editcount BETWEEN 2 and 10 
and r.rc_comment = "User created page with UploadWizard"
limit 100;

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.

SQL

Checking query status...