Untitled query #65098

SQL

set @cat="వైఎస్‌ఆర్_జిల్లా_మండలాలు";
SELECT distinct page_title
FROM page
WHERE
    page_is_redirect = 0 AND
    page_namespace = 0 AND
    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' )
                                                         ))
order by page_title
SQL

Checking query status...
