AP districts improvement in enwiki - current month

SQL

SELECT 
subq.user_name,
COUNT(DISTINCT subq.page_title) as pages_edited,
SUM(subq.Edits) as tot_edits
FROM 
(SELECT
   page_title,
   user_name,
   COUNT(*) as Edits
FROM page
JOIN categorylinks ON cl_from = page_id  AND cl_to="Districts_of_Andhra_Pradesh" AND cl_type="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 page_title !="List_of_districts_of_Andhra_Pradesh"
AND LEFT(rev_timestamp,8)  >= CONCAT(LEFT(REPLACE(CURDATE(),"-", ""),6),"01") AND LEFT(rev_timestamp,8)  <   
REPLACE(CURDATE(),"-", "")
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')
GROUP BY page_title,user_name ) AS subq
GROUP BY subq.user_name
ORDER BY   tot_edits DESC, pages_edited DESC, user_name ASC
LIMIT 100;
SQL

Checking query status...
