wiki 5 lang - Quarry

SQL

-- Select editor's name (actor_name) and count of their revisions (Num_Edits)
SELECT actor.actor_name AS Editor, COUNT(revision.rev_id) AS Num_Edits
FROM revision
-- Join the revision and actor tables to associate revisions with editor
INNER JOIN actor ON actor.actor_id = revision.rev_actor
-- Filter out revisions made by users with 'bot' user group
WHERE NOT EXISTS (   
  SELECT 1 FROM user_groups
  WHERE actor.actor_user = user_groups.ug_user
  AND user_groups.ug_group = 'bot'
)
-- Group the results by editor, aggregating the count of their revisions
GROUP BY Editor 

-- Order the results in descending order of the number of edits
ORDER BY Num_Edits DESC

LIMIT 10 -- Limit the output to the top 10 editors
SQL

Checking query status...
