Edit activitity of main namespace page links from a page -exp

SQL

SELECT
   CONCAT("[[User:",actor_name,"|",actor_name,"]]") as userlink,
   COUNT(*) as edits,
   MAX(LEFT(rev_timestamp,8))  as latest_edit_date
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
WHERE LEFT(rev_timestamp,8)  >= REPLACE(CURDATE() - interval 90 day,'-','') AND LEFT(rev_timestamp,8)  != REPLACE(CURDATE(),'-','')
  AND page_namespace =0 AND  LOWER(actor_name) NOT LIKE '%Bot%' 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 actor_name
HAVING COUNT(*) > 4
ORDER BY edits DESC
LIMIT 100;
SQL

Checking query status...
