Top 10 editors by number of edits in Assamese WP

The following query gives the list of the top ten editors ordered by the number of mainspace edits(shown in the column 'editcount_by_revid') from highest to lowest.
The 'rough_editcount' column is

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
WHERE page_namespace = 0 #Checking for mainspace edits only
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

SQL

Checking query status...