Top Editors of Pages of a main category's direct subcategories

SQL

use tewiki_p;

SELECT  
        CONCAT("[[User:",actor_name,"|",actor_name,"]]") as Editor,
        COUNT(*) as Edits,
        MAX(rev_timestamp) as recent_edit_time
FROM page
JOIN revision ON revision.rev_page = page.page_id
LEFT JOIN revision_actor_temp
      ON revactor_rev=revision.rev_id
LEFT JOIN actor
      ON revactor_actor = actor.actor_id
WHERE (page_title IN 
(SELECT
     page_title
FROM page p
JOIN categorylinks cl
ON p.page_namespace = 0 -- main page
AND cl.cl_from = p.page_id
      AND cl.cl_to in (
SELECT
  page_title as subcat
FROM page p
JOIN categorylinks cl
ON p.page_namespace = 14 -- Optional namespace check. 14 - categories, 6 - files
AND cl.cl_from = p.page_id
      AND cl.cl_to = "ప్రకాశం_జిల్లా_గ్రామాలు" -- Insert your category here.
      )
) AND revactor_actor != 0 ) 

GROUP BY actor_name
HAVING COUNT(*) > 0
ORDER BY Edits DESC LIMIT 50;
SQL

Checking query status...
