Finding the top 10 editors from Assamese Wikipedia

SQL

SELECT a.actor_name, COUNT(a.actor_user) Edit_Count FROM revision AS t /*variable assignments*/
  JOIN actor AS a ON (a.actor_id = t.rev_actor)
  JOIN page AS p ON rev_page=page_id /*The rev_page field holds the latest revision page count while this code is executed by mapping with the page_id fields of the respective page*/
       WHERE a.actor_user NOT IN (SELECT ug_user FROM user_groups WHERE ug_group='bot') AND lower(cast(a.actor_name as CHAR)) NOT LIKE '%bot%' AND page_namespace = 0 /*To optimise the results excluding the user accounts which are under bots user groups or have the name as bot in their user names*/
  GROUP BY a.actor_name HAVING Edit_Count>1000  /*With a criteria of edit count as above 1000 the Top 10 editors will be listed*/
  ORDER BY Edit_Count DESC /* The editor list will be sorted in descending order based on the edit count*/
        limit 10 /*This will limit the results to Top 10*/
SQL

Checking query status...
