Links from incomplete disambiguation pages

SQL

SELECT pl_title, COUNT(pl_from) AS links FROM pagelinks
WHERE pl_namespace = 0 AND pl_from_namespace = 0
AND pl_title IN (
  select page_title from page
  join redirect on rd_from = page_id and rd_namespace = 0
  where page_namespace = 0 and page_is_redirect = 1
  and page_id in (
    select cl_from from categorylinks
    where cl_to in ("Redirects_from_incomplete_disambiguation") and cl_type = 'page'
  )
  and rd_title in (
    select page_title from page
    where page_namespace = 0
    and page_id in (
      select cl_from from categorylinks
      where cl_to = 'All_disambiguation_pages' and cl_type = 'page'
    )
  )
)
/*
AND pl_title IN (
  select page_title from page
  where page_namespace = 0 and page_title like '%\_(%)\_(disambiguation)'
)
*/
GROUP BY pl_title
ORDER BY links DESC
SQL

Checking query status...
