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
SELECT * 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\\)$', ''))
;
SELECT * FROM page WHERE page_namespace=0 AND page_title REGEXP '_\\(hoofdbetekenis\\)$' AND page_is_redirect=1 LIMIT 10

SQL

Checking query status...