Edit activitity of main namespace page links from a page

Fork of Edit activitity of main namespace 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 (more than 4 edits) and its internal links to main namespace.  Helps in strengthening the team contributing to a prominent article and its links

SQL

SELECT
   CONCAT("[[User:",user_name,"|",user_name,"]], ") as userlink,

FROM revision
JOIN page ON revision.rev_page = 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(),'-','')
  AND page_namespace =0 AND 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))
GROUP BY user_name
HAVING COUNT(*) > 4
ORDER BY edits DESC
LIMIT 100;

SQL

Checking query status...