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;