New editors with exactly 10 recent edits all within an hour, not blocked

SQL

WITH byaccount AS (SELECT actor_name, MAX(rc_timestamp) AS last_edit, COUNT(*) AS edits
/*,  TIME_TO_SEC(TIMEDIFF(STR_TO_DATE(MAX(rc_timestamp),"%Y%m%d%H%i%s"),STR_TO_DATE(MIN(rc_timestamp),"%Y%m%d%H%i%s"))) AS tsdiff, 
user_registration, REPLACE(REPLACE(REPLACE(CURTIME() - INTERVAL 30 DAY,"-","")," ",""),":","") AS ur_limit*/
FROM recentchanges
JOIN actor ON actor_id=rc_actor
JOIN `user` ON user_id=actor_user AND user_registration >= (SELECT MIN(rc_timestamp) FROM recentchanges)
WHERE rc_type IN (0,2)
GROUP BY actor_name
HAVING COUNT(*) BETWEEN 5 AND 15 AND TIME_TO_SEC(TIMEDIFF(STR_TO_DATE(MAX(rc_timestamp),"%Y%m%d%H%i%s"),STR_TO_DATE(MIN(rc_timestamp),"%Y%m%d%H%i%s"))) <= 3600
AND NOT EXISTS (SELECT 1 FROM ipblocks WHERE ipb_user=actor_user AND ipb_expiry='infinity' AND ipb_sitewide!=0)
)
SELECT edits, COUNT(*) AS accounts FROM byaccount GROUP BY edits ORDER BY edits

SQL

Checking query status...