nlwiki Page titles and links with a sequence of apostrophes

SQL

# existing non-redirect pages with ''
SELECT page_namespace AS ns1, page_title AS page_title1
FROM page
WHERE page_namespace NOT IN (2,3) AND page_title REGEXP '\'\'' AND page_is_redirect=0
ORDER BY ns, page_title;

# template links to pages with '' not coming from cascade-protected pages
SELECT
	page_namespace AS fns2, page_title AS ftitle2,
    lt_namespace AS tns2, lt_title AS ttitle2,
    (EXISTS (SELECT * FROM page pt WHERE pt.page_namespace=lt_namespace AND pt.page_title=lt_title)) AS 'exists'
FROM templatelinks, page, linktarget
WHERE
	page_namespace NOT IN (2,3) AND
    #NOT (page_namespace=4 AND page_title REGEXP '^Beveiligd/|^Te_(beoordelen|verwijderen)_') AND
    #NOT (page_namespace IN (4,5,12) AND page_title REGEXP '/Archief') AND
	tl_from=page_id AND 
    tl_target_id=lt_id AND
    lt_title REGEXP '\'\'' AND
    NOT EXISTS (SELECT * FROM page_restrictions WHERE pr_page=page_id AND pr_cascade=1)
ORDER BY `exists`, fns, ftitle;

# page links to pages with ''
SELECT
	page_namespace AS fns3, page_title AS ftitle3,
    pl_namespace AS tns3, pl_title AS ttitle3,
    (EXISTS (SELECT * FROM page pt WHERE pt.page_namespace=pl_namespace AND pt.page_title=pl_title)) AS 'exists'
FROM pagelinks, page
WHERE
	page_namespace NOT IN (2,3) AND
    NOT (page_namespace=4 AND page_title REGEXP '^Beveiligd/|^Te_(beoordelen|verwijderen)_') AND
    NOT (page_namespace IN (4,5,12) AND page_title REGEXP '/Archief') AND
	pl_from=page_id AND 
    pl_title REGEXP '\'\''
ORDER BY `exists`, fns, ftitle
SQL

Checking query status...
