Active editors for linked pages of AP districts category from 20220403

SQL

SELECT
   CONCAT("[[user:",user_name,"]]") as user_page,
   COUNT(*) as Edits
FROM (
  SELECT
   DISTINCT pagel.page_id, pl_namespace, pl_title
  FROM page
  JOIN categorylinks ON cl_from = page_id  AND cl_to="ఆంధ్రప్రదేశ్_జిల్లాలు" AND cl_type="page"
  JOIN pagelinks ON pl_from=page_id AND pl_from_namespace=page_namespace
  JOIN page pagel ON pagel.page_namespace=pl_namespace AND pagel.page_title=pl_title ) as pageset
JOIN revision      ON pageset.page_id = rev_page
JOIN actor      ON rev_actor = actor_id
JOIN user   ON user_id =actor_user
where   rev_actor != 0 AND pageset.pl_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 user_name
HAVING Edits > 4
ORDER BY   Edits DESC, user_name ASC
LIMIT 3000;

SQL

Checking query status...