nlwiki Anomalous "hoofdbetekenis" constructions

SQL

SELECT 
	p1.page_title AS page_title1, 
    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 ON 
    	r1.rd_namespace=p2.page_namespace AND 
        LEFT(p1.page_title,LENGTH(p1.page_title)-17)=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)') AND
    (p2.page_is_redirect=0 OR r1.rd_title!=r2.rd_title)
ORDER BY p1.page_title

SQL

Checking query status...