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.