AP districts update 2023 - current month page wise edit details

Fork of AP districts improvement in enwiki - current month by Arjunaraoc

This query is marked as a draft This query has been published by Arjunaraoc.

AP districts pages excluding list articles improvement activity  of current month group by  each article, with editor while showing count of  edits.

SQL

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 
ORDER BY   page_title ASC, user_name ASC
LIMIT 100;

SQL

Checking query status...