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 page_namespace=0 AND Pt.page_title=pl_title
WHERE page_namespace=0 AND 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
  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"
  FROM targets
  WHERE Rd = 1
  ORDER BY Title
)
SQL

Checking query status...
