Top human editors of the prev. week as per talk page category

SQL

# Unique human editors and their total edits for a list of articles specified by category, excluding few as may be
# Prev monday-sunday https://stackoverflow.com/questions/12422248/previous-monday-previous-sundays-date-based-on-todays-date
SET @pweekbegin=DATE_FORMAT(CURDATE() - INTERVAL (WEEKDAY(CURDATE()+5)%7)) DAY,'%Y-%m-%d'), 
 @pweekend=DATE_FORMAT(CURDATE() - INTERVAL(WEEKDAY(CURDATE())+6)%7)) DAY , '%Y-%m-01');
SELECT  
    subqres.user_name,
    COUNT(DISTINCT  subqres.page_title) as pages_edited,
    SUM(subqres.Edits) as tot_edits
FROM(
SELECT page_title,
       user_name,
       COUNT(*) as Edits
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)  >= pweekbegin
  AND LEFT(rev_timestamp,8)  <= pweekend
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')
AND  page.page_title IN
  (SELECT page_title
  FROM page
  JOIN categorylinks ON cl_from = page_id  AND cl_to="WikiProject_Andhra_Pradesh_articles" AND cl_type="page")
GROUP BY page_title,user_name
) as subqres
GROUP BY subqres.user_name
HAVING tot_edits >29
ORDER BY tot_edits DESC, pages_edited DESC, user_name ASC
LIMIT 100;
SQL

Checking query status...
