Links from incomplete disambiguation pages

SQL

SELECT p1.page_title, p2.page_title
FROM page p1 LEFT 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
AND 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_is_redirect = 0
  and p3.page_id in (select cl_from from categorylinks where cl_to = 'All_disambiguation_pages' and cl_type = 'page')
)
*/
SQL

Checking query status...
