Untitled query #67872

SQL

ELECT page_title FROM page,categorylinks
where page_id not in (select tl_from from templatelinks 
                      where tl_from_namespace =0 
                      and tl_namespace =10 
                      and (tl_title like "%సమాచారపెట్టె%" or tl_title like "%Infobox%"))
		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' )
  				)

		and page_namespace = 0
order by page_title
SQL

Checking query status...
