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 and cl_type = 'subcat' )
  			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 and cl_type = 'subcat' ) and cl_type = 'subcat' )
 			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 cl_type = 'subcat' ) and cl_type = 'subcat' ) and cl_type = 'subcat' )
               ))) and
 	page_namespace = 0 and
	rev.page=page_id and
    actor_id=rev_actor and
    actor_name= "Ahmed Nisar"
    
  ORDER BY 
  actor_name
SQL

Checking query status...
