Links to dabs from a given page

SQL

WITH targets AS (
  SELECT pl_title AS Title, Pt.page_id AS Id, Pt.page_is_redirect AS Rd
  FROM page Pf
  JOIN pagelinks ON pl_from = Pf.page_id AND pl_namespace=0
  JOIN page Pt ON Pt.page_namespace=0 AND Pt.page_title=pl_title
  WHERE Pf.page_namespace=0 AND Pf.page_title = "U"
)
  SELECT Title, "" AS Redir
  FROM targets
  JOIN categorylinks ON cl_from=Id AND cl_type="page" AND cl_to="All_disambiguation_pages"
  WHERE Rd = 0
UNION
  SELECT Title, rd_title AS Redir
  FROM targets
  JOIN redirect ON rd_from=Id AND rd_namespace=0
  JOIN page ON page_namespace=0 AND page_title=rd_title
  JOIN categorylinks ON cl_from=page_id AND cl_type="page" AND cl_to="All_disambiguation_pages"
  WHERE Rd = 1
ORDER BY Title
SQL

Checking query status...
