SELECT dabpage.page_title, frompage.page_title

FROM page dabpage

JOIN categorylinks cl

    ON cl.cl_from = dabpage.page_id

    AND cl.cl_to = 'All_article_disambiguation_pages'

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

LIMIT 1000;