Untitled query #84189

SQL

SELECT
DISTINCT(actor_name), COUNT(rev.rev_id) as num_edits
FROM revision as rev
JOIN actor on actor_id = rev_actor
#JOIN user on user_id = actor_user
WHERE YEAR(rev.rev_timestamp) = 2024 AND MONTH(rev.rev_timestamp) = 5
AND actor_user IS NOT NULL
AND NOT EXISTS (   -- the following subquery selects users that have 'bot' group affiliation, and NOT EXISTS filters them out
  SELECT 1 FROM user_groups
  WHERE actor.actor_user = user_groups.ug_user
  AND user_groups.ug_group = 'bot' OR user_groups.ug_group = 'NULL'
)
GROUP BY actor_name
ORDER BY num_edits DESC
#LIMIT 10;
SQL

Checking query status...
