AP districts restructure edit in enwiki activity from 20220404 to 20230403

AP districts restructure edit activity in enwiki from 20220404 to 20230403, with atleast 3 edits, group by  each article, with corresponding number of editors and sum of total such edits.

SQL

Select 
   SR.page_title,
   COUNT(SR.user_name) as Num_users,
   SUM(SR.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 LEFT(rev_timestamp,8)  >= "20220403"
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
HAVING   Edits > 2
ORDER BY   page_title ASC, Edits DESC AS SR
)

SQL

Checking query status...