SELECT DISTINCT page1.page_title AS thepage

    ,pl_title AS thelink

FROM pagelinks

INNER JOIN page AS page1 ON pl_from = page_id

INNER JOIN page AS page2 ON page2.page_title = pl_title

INNER JOIN templatelinks ON page1.page_id = tl_from

INNER JOIN categorylinks ON cl_from = page2.page_id

WHERE cl_to = "Disambiguation_pages"

    AND page1.page_namespace = 0

    AND page1.page_is_redirect = 0

    AND tl_title != "Dn";