Top 10 editors by number of edits in Gujarathi WP

SQL

SELECT user_name, COUNT(DISTINCT(rev_id)) AS editcount_by_revid, user_editcount AS rough_editcount #Selecting necessary columns 
FROM revision #Choosing the required table to pull data
JOIN page ON rev_page = page_id #Inner joining page on revision table
JOIN actor ON rev_actor = actor_id #Inner joining actor on revision table
JOIN user ON actor_user = user_id AND actor_user IS NOT NULL #inner joining user on actor table & removing NULL valued usernames in data
JOIN user_groups ON user_id = ug_user #Left joining user groups
WHERE page_namespace = 0 AND (LOWER(CAST(user_name AS CHAR)) NOT LIKE '%bot%') AND (ug_group IS NULL OR ug_group != 'bot')
GROUP BY user_name
ORDER BY  editcount_by_revid DESC
LIMIT 10
SQL

Checking query status...
