Most active non-admins at AN(/i,3RR) (excluding archiving)

Fork of Most active non-admins at AN by Vexations

This query is marked as a draft This query has been published by 15.

SQL

SELECT actor_name, COUNT(actor_name) AS edits
FROM revision JOIN actor ON rev_actor = actor_id
  JOIN user_groups ON actor_user = ug_user
  JOIN comment ON rev_comment_id = comment_id
  WHERE rev_page = 5137507 # AN = 5149102, ANI = 5137507, 3RR = 3741656
      # AND rev_timestamp > (NOW() - INTERVAL 1 year)
      AND ug_user NOT IN (SELECT DISTINCT user_groups.ug_user FROM user_groups WHERE ug_group = 'sysop' OR ug_group = 'bot')
      AND comment_text NOT LIKE "%OneClickArchiver%"
GROUP BY actor_name
ORDER BY edits DESC;

SQL

Checking query status...