AP districts restructure edits pagewise from 20220403

SQL

SELECT
   page_title,
   page_len as page_size,
   COUNT(*) as Edits
FROM page
JOIN categorylinks ON cl_from = page_id  AND cl_to="ఆంధ్రప్రదేశ్_జిల్లాలు" 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 ='CommonsDelinker')
GROUP BY page_title
ORDER BY    Edits DESC,page_title ASC
LIMIT 10000;

SQL

Checking query status...