Edit count and previous groups for a category of sock users

SQL

SELECT user_id, user_name, user_editcount, user_registration, COUNT(*) as 'MainspaceEdits1m' FROM revision_userindex
	   JOIN page ON page_id = rev_page
	   JOIN actor_user on rev_actor = actor_id
	   JOIN `user` on actor_user=user_id
       WHERE user_id in (
         SELECT user_id
            FROM `user`
            WHERE user_editcount > 7000
              AND user_registration < date_add(now(), interval -90 day) -- registered more than 3 months back
              AND EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'extendedconfirmed')
              AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group in ( 'sysop', 'patroller', 'bot' ))
              AND NOT EXISTS (SELECT 1 FROM logging_logindex
                              WHERE user_name = log_title
                                AND log_namespace = 2
                                AND log_type = 'block' AND log_action = 'block')
        )
        and rev_timestamp >= date_add(now(), interval -30 day)
         AND page_namespace = 0 -- Mainspace, from [[WP:Namespaces]]
       group by rev_actor
       having count(*) > 300
       order by count(*) desc
SQL

Checking query status...
