Edit activitity of main namespace page links from a page

Fork of Edit activitity of internal page links from a page by Arjunaraoc

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

Identify top editors of a page and its internal links to main namespace.  Helps in strengthening the team contributing to a prominent article and its links

SQL

Select pagesl.page_id
FROM 
(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) AS pagesel
JOIN (
SELECT
   rev_page,
   user_name
#   COUNT(*) as admin_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 7 day,'-','') AND LEFT(rev_timestamp,8)  != REPLACE(CURDATE(),'-','')
  AND page_namespace =0) AS users
ON users.rev_page = pagesl.page_id 
LIMIT 100;

SQL

Checking query status...