nlwiki Anomalous "hoofdbetekenis" constructions

SQL

USE nlwiki_p;
SELECT 
	p1.page_title AS page_title1, 
    r1.rd_title AS rd_title1, 
    p2.page_id AS page_id2, 
    r2.rd_title AS rd_title2
FROM page p1
	INNER JOIN redirect r1 ON p1.page_id=r1.rd_from
    LEFT JOIN page p2 ON r1.rd_namespace=p2.page_namespace AND r1.rd_title=p2.page_title
    LEFT JOIN redirect r2 ON 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

SQL

Checking query status...