Fork of HK anon 3 by
This query is marked as a draft This query has been published by .

SQL

AخA
 
USE commonswiki_p;
SELECT actor_name AS Editor,
    MIN(LEFT(rev_timestamp,8)) AS Date
FROM page
JOIN categorylinks ON page_id=cl_from
JOIN revision ON page_id=rev_page
JOIN comment_revision ON comment_id = rev_comment_id
JOIN image ON page_title=img_name
JOIN actor_revision on rev_actor = actor_id
WHERE
    cl_to = 'Photographs_by_Anonymous_Hong_Kong_Photographer_1'
AND comment_text = "User created page with UploadWizard"
AND actor_name NOT REGEXP "[bB]ot$"
AND rev_timestamp > 20191000000000
GROUP BY actor_name
ORDER BY Date;
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.

Checking query status...