nlwiki Red links that appear to have a namespace prefix

SQL

SELECT 
	fp.page_namespace AS fn, 
    fp.page_title AS ft, 
    pl_namespace AS tn, 
    pl_title AS tt, 
    MIN(rev_timestamp) AS created,
    EXISTS (SELECT * FROM page WHERE page_namespace=pl_namespace AND page_title=REGEXP_REPLACE(pl_title, ':+', ':_')) AS sp
FROM pagelinks, page fp, revision
WHERE
	pl_namespace=0 AND
    pl_title REGEXP '^[A-Z][a-z]{2,}([_\\-][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_') AND
    NOT (pl_namespace=0 AND pl_title REGEXP '^O(verleg_o)?nderwijsprogramma:') AND
    rev_parent_id=0 AND
    rev_page=fp.page_id
GROUP BY fn, ft, tn, tt
ORDER BY sp DESC, created DESC
SQL

Checking query status...
