SELECT page_title AS pagename

    ,pl_title AS link

FROM pagelinks

INNER JOIN page ON pl_from = page_id

WHERE pl_from_namespace = 0

    AND page_is_redirect = 0

    AND pl_title IN (

        SELECT page_title

        FROM categorylinks

        INNER JOIN page ON page_id = cl_from

        WHERE cl_to = "Disambiguation_pages"

            AND cl_from = page_id

        )

    AND page_id NOT IN (

        SELECT tl_from

        FROM templatelinks

        WHERE tl_title = "Dn"

            AND tl_from = page_id

        );