nlwiki Red links that appear to have a namespace prefix

Fork of nds_nlwiki Red links that appear to have a namespace prefix by Bdijkstra

This query is marked as a draft This query has been published by Bdijkstra.

SQL

USE nlwiki_p;
SELECT fp.page_namespace AS 'fns', fp.page_title AS 'ft', pl_namespace AS 'tns', pl_title AS 'tt'
FROM pagelinks, page fp
WHERE
	pl_namespace=0 AND
    pl_title REGEXP '^[A-Z][a-z_]+:[^_]' AND
    NOT EXISTS (SELECT * FROM page tp WHERE tp.page_namespace=pl_namespace AND tp.page_title=pl_title) AND
    pl_from=fp.page_id AND
    fp.page_namespace NOT IN (2, 3) AND
    NOT (fp.page_namespace!=0 AND fp.page_title REGEXP '/[Aa]rchief') AND
    NOT (fp.page_namespace=4 AND fp.page_title REGEXP '^Te_(beoordelen|verwijderen)_(pagina\'s|sjablonen)/Toegevoegd_')
ORDER BY tns, tt

SQL

Checking query status...