Top 10 editors by number of edits in Assamese 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
LEFT JOIN user_groups ON user_id = ug_user #Left joining user groups on users as few users are not part of any groups
WHERE page_namespace = 0 #Checking for mainspace edits only
AND (LOWER(CAST(user_name AS CHAR)) NOT LIKE '%bot%') AND (ug_group IS NULL OR ug_group != 'bot') #Discarding bots from data
GROUP BY user_name #Grouping by user_name to get the editcount by counting the revision ids  
ORDER BY editcount_by_revid DESC #Getting the data from highest edit count to lowest edit count
LIMIT 10 #Limiting to only ten editors
SQL

Checking query status...
