USE nlwiki_p;

SELECT dabpage.page_title, frompage.page_title

FROM page dabpage

JOIN templatelinks

    ON tl_from = dabpage.page_id

    AND tl_from_namespace = 0

    AND tl_namespace = 10

    AND tl_title = 'Dp'

JOIN pagelinks

    ON pl_namespace = 0

    AND pl_title = dabpage.page_title

    AND pl_from_namespace = 0

JOIN page frompage

    ON frompage.page_id = pl_from

    AND frompage.page_namespace = 0

    AND frompage.page_is_redirect = 0;