Untitled query #79426

SQL

SELECT concat("[[",page_title,"]]"),count(page_title) redlinksCount
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 = 'General_elections_in_India_by_state_or_union_territory'
  OR
  cl_to IN (select page_title from page inner join categorylinks on cl_from = page_id where cl_to = 'General_elections_in_India_by_state_or_union_territory' 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)
  group by page_title
  having count(page_title)>4
  order by count(page_title) desc, page_title
SQL

Checking query status...
