Untitled query #32355

SQL

SELECT
  rev_user_text, user_editcount, COUNT(*)
FROM revision_userindex
JOIN user ON rev_user_text = user_name
JOIN user_groups ON user_id = ug_user
JOIN page AS article ON rev_page = article.page_id
JOIN page AS usertalk ON usertalk.page_title = rev_user_text
WHERE article.page_namespace = 0
AND usertalk.page_namespace = 3
AND user_editcount < 10000
AND ug_group NOT IN ('abusefilter', 'abusefilter-helper', 'accountcreator', 'autoreviewer', 'bot', 'bureaucrat', 'checkuser', 
                     'confirmed', 'copyviobot', 'epadmin', 'eventcoordinator', '_extendedconfirmed', 'extendedmover', 
                     'filemover', 'flow-bot', 'founder', 'import', 'interface-admin', 'ipblock-exempt', 'massmessage-sender',
                     'oversight', 'patroller', 'researcher', 'reviewer', 'rollbacker', 'sysop', 'templateeditor')
AND rev_timestamp > (NOW() - INTERVAL 1 WEEK) 
AND usertalk.page_title NOT IN 
    (
      SELECT page_title
      FROM revision_userindex
      JOIN change_tag ON ct_rev_id = rev_id
      JOIN page ON rev_page = page_id
      WHERE page_namespace = 3
      AND ct_tag = 'wikilove'
    ) 
GROUP BY rev_user_text
HAVING COUNT(*) > 70
ORDER BY COUNT(*) DESC;
#LIMIT 50;
SQL

Checking query status...
