Top 10 editors by number of edits in Telugu WP

SQL

WITH
rev_filter AS (
  SELECT rev_actor, rev_page, COUNT(DISTINCT(rev_id)) as edit_count
  FROM revision
  WHERE rev_actor IS NOT NULL
  GROUP BY rev_actor
),
edits_filter AS(
  SELECT DISTINCT(actor_name) as username, edit_count, user_editcount as rough_editcount
  FROM rev_filter
  JOIN actor ON actor_id = rev_actor
  JOIN page ON page_id = rev_page AND page_namespace = 0
  JOIN user ON actor_user = user_id
  JOIN user_groups ON ug_user = user_id
  WHERE ((ug_group IS NULL)) AND LOWER(rev_actor) NOT LIKE '%bot%'
)
SELECT *
FROM edits_filter
ORDER BY edit_count DESC
LIMIT 10

SQL

Checking query status...