USE nlwiki_p;

SELECT p1.page_title, r1.rd_title AS rd_title1, r2.rd_title AS rd_title2

FROM page p1

    INNER JOIN redirect r1 ON p1.page_id=r1.rd_from

    LEFT JOIN page p2, redirect r2 ON r1.rd_namespace=p2.page_namespace AND r1.rd_title=p2.page_title AND p2.page_id=r2.rd_from

WHERE

    p1.page_namespace=0 AND

    p1.page_is_redirect=1 AND

    p1.page_title REGEXP '_\\(hoofdbetekenis\\)$' AND

    p1.page_title!=CONCAT(r1.rd_title,'_(hoofdbetekenis)')

ORDER BY p1.page_title