Admins by edit count August

SQL

SELECT user_id, user_name, edits
  SUBSTR(rev_timestamp, 1, 6) AS MONTH,
  COUNT(rev_id) AS edits
FROM revision
JOIN change_tag ON ct_rev_id = rev_id
JOIN user ON rev_user = user_id
WHERE EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'sysop')
AND user_editcount > 1000
GROUP BY MONTH;


SELECT user_id, user_name, user_editcount, user_registration, edits
FROM `user`
WHERE EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'sysop')

  AND (SELECT COUNT(*) FROM logging_userindex WHERE user_id=log_user AND log_type = 'move' LIMIT 5) >= 5
  AND (SELECT COUNT(*) FROM revision_userindex
       WHERE rev_user = user_id
         AND rev_timestamp >= 20171125000000
       LIMIT 500) >= 500
  AND (SELECT
  SUBSTR(rev_timestamp, 1, 6) AS MONTH,
  COUNT(rev_id) AS edits
SQL

Checking query status...
