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, MIN(rev_timestamp)
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
    rev_parent_id=0 AND
    rev_page=fp.page_id
GROUP BY fns, ft, tns, tt
ORDER BY rev_timestamp DESC

SQL

Checking query status...