Edit activitity of internal page links from a page

Fork of Old Links from cup to Disambiguation pages , de by Doktor Wu

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

SQL

SELECT
     user_name,
     COUNT(*) as edits,
     MAX(LEFT(rev_timestamp,8))  as latest_edit_date
     page_id
FROM page
Where page_namespace=0 AND page_title IN (
SELECT pl_title
FROM  page, pagelinks
Where page_title='ఆంధ్రప్రదేశ్' AND
	pl_from_namespace = 0
  AND pl_from =page_id AND pl_namespace=0)
JOIN revision on  revision.rev_page =page_id
JOIN revision_actor_temp
     ON  revactor_rev=rev_id
JOIN actor
     ON revactor_actor=actor_id
JOIN user
     ON user_id =actor_user
WHERE LEFT(rev_timestamp,8)  >= REPLACE(CURDATE() - interval 90 day,'-','') AND LEFT(rev_timestamp,8)  != REPLACE(CURDATE(),'-','')
ORDER BY edits DESC
Limit 1000;

SQL

Checking query status...