Top human editors of pages based on talk page category

SQL

# Unique human editors and their total edits for a list of articles specified by category, excluding few as may be
SET @pmonthbegin=DATE_FORMAT(CURDATE() - INTERVAL 1 MONTH,'%Y-%m-01'),
 @nmonthbegin=DATE_FORMAT(CURDATE() , '%Y-%m-01');
SELECT
   page_title,
   subqres.user_name,
   COUNT(*) as Edits
FROM page
JOIN categorylinks ON cl_from = page_id  AND cl_to="WikiProject_Andhra_Pradesh_articles" AND cl_type="page"
JOIN (SELECT page_title, user_name
from page
JOIN revision      ON page_id = rev_page
JOIN actor      ON rev_actor = actor_id
JOIN user   ON user_id =actor_user
where   rev_actor != 0 AND page_namespace=0
AND LEFT(rev_timestamp,8)  >= REPLACE(@pmonthbegin,"-","")AND LEFT(rev_timestamp,8)  < REPLACE(@nmonthbegin,"-","")
AND NOT (user_name LIKE '%AWB%' OR user_name  LIKE '%Bot%' OR user_name LIKE'%bot%' OR  user_name LIKE '%BOT%' OR user_name ='CommonsDelinker'))
 as subqres on page_title=subqres.page_title
GROUP BY page_title,user_name 
GROUP BY subqres.user_name
ORDER BY tot_edits DESC, pages_edited DESC, user_name ASC
LIMIT 100;
SQL

Checking query status...
