Tewiki:Creator wise New articles in a specific Category

SQL

set @cat:= "ప్రపంచ_దేశాలు";
SELECT 
    actor_name, count(actor_name)
FROM
    page,actor,revision
  WHERE
    page_id in (select cl_from from categorylinks where cl_to =@cat
                OR
  				cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = @cat)
  			OR
  				cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = @cat) )
 			OR
 				cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = @cat)))
               ) and
 	page_namespace = 0 and
	rev_page=page_id and
    actor_id=rev_actor and
    rev_parent_id=0
--    actor_name= "Ahmed Nisar"
  group by actor_name  
  ORDER BY 
  actor_name
SQL

Checking query status...
