Untitled query #63939

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...
