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

SQL

SELECT actor_name, MAX(rc_timestamp) AS last_edit
/*,  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(*)=10 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)
ORDER BY actor_name

SQL

Checking query status...