List of Red links in Andhra Pradesh village pages

SQL

SELECT page_title,pl_title Redlink
FROM pagelinks,categorylinks,page
WHERE
	cl_from=pl_from and
    page_id=pl_from and
    pl_namespace=0 AND
    pl_from_namespace = 0 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
    not exists (select page_title
                from page 
                where page_title = pl_title
                and page_namespace = 0)
  order by page_title
SQL

Checking query status...
