SQL
AخA
USE commonswiki_p;
SELECT count(*)
FROM recentchanges
WHERE rc_log_type = "upload"
AND rc_log_action = "upload"
AND rc_namespace = 6
AND rc_timestamp >= 20180208000000
AND rc_user_text != "Mr.Nostalgic"
AND rc_comment != "User created page with UploadWizard"
AND rc_comment NOT LIKE "Transferred"
AND rc_comment NOT LIKE "Uploaded"
/*ORDER BY rc_timestamp DESC LIMIT 20*/
;
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.