Tewiki:Creator wise New articles in a specific Category

SQL

set @cat:= "ఆసియా_దేశాలు";
SELECT 
    actor_name, page_title
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
--  group by rev_actor
  ORDER BY rev_actor desc
SQL

Checking query status...
