HK anon listing

SQL

USE commonswiki_p;
SELECT actor_name AS Editor,
	COUNT(actor_name) AS Uploads,
	LEFT(rev_timestamp,6) 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 rev_timestamp BETWEEN 20191000000000 AND 20191100000000
GROUP BY actor_name, Date
ORDER BY Date;
SQL

Checking query status...
