AP districts restructure detailed pagewise edit activity from 20220403

Fork of New article initiators and pages in year by Arjunaraoc

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

SQL

SELECT
   page_title,
   user_name
   COUNT(*) as Edits
FROM revision
LEFT JOIN page
      ON page_id = rev_page
LEFT JOIN actor
      ON rev_actor = actor_id
LEFT JOIN  user   ON user_id =actor_user
JOIN categorylinks cl ON page_namespace = 0 AND cl.cl_from = page_id       AND cl.cl_to LIKE "ఆంధ్రప్రదేశ్_జిల్లాలు"
where   rev_actor != 0 AND page_namespace=0 AND rev_parent_id = 0 
AND LEFT(rev_timestamp,8)  >= REPLACE(CURDATE() - interval 7 day,'-','') AND LEFT(rev_timestamp,8)  != REPLACE(CURDATE(),'-','')
GROUP BY page_title,
ORDER BY   page_title ASC
LIMIT 10000;

SQL

Checking query status...