Links from incomplete disambiguation pages

SQL

/*
SELECT p1.page_title, p2.page_title FROM page p1
JOIN pagelinks ON pl_from = p1.page_id AND p1.page_namespace = 0 AND pl_from_namespace = 0
JOIN page p2 ON pl_title = p2.page_title AND p2.page_namespace = 0 AND pl_namespace = 0
-- WHERE p2.page_title like '%\_(%)\_(disambiguation)'
WHERE p2.page_id IN (
  select cl_from from categorylinks
  where cl_to in ("Redirects_from_incomplete_disambiguation") and cl_type = 'page'
)
AND p2.page_id IN (
  select rd_from from redirect
  join page p3 on rd_title = p3.page_title and rd_namespace = 0 and p3.page_namespace = 0
  where p3.page_id in (select cl_from from categorylinks where cl_to = 'All_disambiguation_pages' and cl_type = 'page')
)
*/

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
  where page_namespace = 0 AND page_title like '%\_(%)\_(disambiguation)'
)
GROUP BY pl_title
ORDER BY links DESC
SQL

Checking query status...
