nlwiki List hoofdbetekenis pages

SQL

# should be redirect
SELECT page_title FROM page WHERE page_namespace=0 AND page_title REGEXP '_\\(hoofdbetekenis\\)$' AND page_is_redirect=0
;
# base page should exist and should not be a redirect
SELECT page_title FROM page hp WHERE page_namespace=0 AND page_title REGEXP '_\\(hoofdbetekenis\\)$' AND page_is_redirect=1 AND NOT EXISTS 
	(SELECT * FROM page bp WHERE page_namespace=0 AND bp.page_title=REGEXP_REPLACE(hp.page_title, '_\\(hoofdbetekenis\\)$', '')) OR EXISTS 
	(SELECT * FROM page bp WHERE page_namespace=0 AND bp.page_title=REGEXP_REPLACE(hp.page_title, '_\\(hoofdbetekenis\\)$', '') AND
     bp.page_is_redirect=0)
;
# the list you came for
SELECT page_title, REGEXP_REPLACE(hp.page_title, '_\\(hoofdbetekenis\\)$', '') AS base
FROM page
WHERE page_namespace=0 AND page_title REGEXP '_\\(hoofdbetekenis\\)$' AND page_is_redirect=1
SQL

Checking query status...
