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
  GROUP BY rev_actor
  #ORDER BY edit_count DESC
),
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 AND rev_actor IS NOT NULL AND LOWER(rev_actor) NOT LIKE '%bot%' 
  JOIN page on page_id = rev_page AND page_namespace = 0
  JOIN user on actor_user = user_id
  LEFT JOIN user_groups on ug_user = user_id
  WHERE (ug_group IS NULL) OR (ug_group = 'bot')  
)
SELECT *
FROM edits_filter
ORDER BY edit_count DESC
LIMIT 10

SQL

Checking query status...