Tewiki:Mandalam pages in a State

SQL

SELECT page_title,page_len FROM page,categorylinks
where  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
--        and page_len<10000
order by page_len,page_title
SQL

Checking query status...
