# existing non-redirect pages with ''

SELECT page_namespace AS ns, page_title

FROM page

WHERE page_namespace NOT IN (2,3) AND page_title REGEXP '\'\'' AND page_is_redirect=0

ORDER BY ns, page_title;

​

# links to pages with '' not coming from cascade-protected pages

SELECT

    page_namespace AS fns, page_title AS ftitle,

    tl_namespace AS tns, tl_title AS ttitle,

    (EXISTS (SELECT * FROM page pt WHERE pt.page_namespace=tl_namespace AND pt.page_title=tl_title)) AS 'exists'

FROM templatelinks, 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

    tl_from=page_id AND 

    tl_title REGEXP '\'\'' AND

    NOT EXISTS (SELECT * FROM page_restrictions WHERE pr_page=page_id AND pr_cascade=1)

ORDER BY `exists`, fns, ftitle;

​

/*SELECT

    page_namespace AS fns, page_title AS ftitle,

    pl_namespace AS tns, pl_title AS ttitle,

    (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*/