Untitled query #55346

SQL

select distinct page_title from categorylinks inner join page on page_id = cl_from
where (
  (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' )
  )
  and page_namespace=0
)
SQL

Checking query status...
