Tewiki:People pages sans Infobox

SQL

SELECT distinct page_title FROM page p1,categorylinks
where p1.page_id not in (select tl_from from templatelinks 
                      where tl_from_namespace =0 
                      and tl_namespace =10 
                      and p1.page_is_redirect=0
                      and (tl_title like "%సమాచారపెట్టె%" or tl_title like "%Infobox%"))
                      and p1.page_title not in (select p2.page_title from page p2 where p2.page_namespace=1 and p2.page_id in (select tl_from from templatelinks where tl_title like "%Infobox_requested%" and tl_from_namespace=1))
		and page_id=cl_from
        and (cl_to = 'ప్రజలు'
  			OR
  				cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'ప్రజలు' 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 = 'ప్రజలు' 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 = 'ప్రజలు' and cl_type = 'subcat' ) 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 in (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'ప్రజలు' and cl_type = 'subcat' ) and cl_type = 'subcat' ) and cl_type = 'subcat' ) and cl_type = 'subcat' )
  				)

		and page_namespace = 0
order by p1.page_title
SQL

Checking query status...
