Untitled query #89549

SQL

SELECT 
    actor.actor_name AS user,
    page.page_namespace AS namespace_id,
    COUNT(revision.rev_id) AS contributions
FROM revision
JOIN actor ON actor.actor_id = revision.rev_actor
JOIN page ON page.page_id = revision.rev_page
WHERE page.page_namespace = 2
  AND actor.actor_user NOT IN (
      SELECT ug_user 
      FROM user_groups 
      WHERE ug_group = 'bot'
  )
  AND actor.actor_name NOT IN (
      SELECT gu_name 
      FROM globaluser_groups 
      WHERE gu_group = 'bot'
  )
GROUP BY actor.actor_name, page.page_namespace
ORDER BY contributions DESC
LIMIT 20 OFFSET 0;
SQL

Checking query status...
