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
FROM revision
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(),'-','')
AND revision.rev_page in (
SELECT 
     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))
ORDER BY edits DESC
Limit 1000;

SQL

Checking query status...