USE nlwiki_p;

SELECT page_title, rd_namespace, rd_title, rd_fragment, rd_interwiki

FROM (

    SELECT page_id, page_title

    FROM page

    WHERE

        page_namespace=0 AND

        page_is_redirect=1 AND

        page_title REGEXP '_\\(hoofdbetekenis\\)$'    

    LIMIT 100) p INNER JOIN redirect ON page_id=rd_from

WHERE

    rd_namespace!=0 OR

    rd_fragment!='' OR

    rd_interwiki!='' OR

    page_title!=CONCAT(rd_title,'_(hoofdbetekenis)')