nlwiki Station articles w/ bad catsort

Fork of nlwiki Page titles starting with an article w/ bad catsort by Bdijkstra

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

SQL

SELECT
	page_namespace AS ns, page_title, rev_timestamp AS 'created', cl_to, cl_sortkey_prefix
FROM categorylinks, revision, page
WHERE page_namespace=0 AND page_id=cl_from AND cl_sortkey_prefix='' AND cl_to NOT REGEXP '^Wikipedia:' AND cl_to REGEXP '[Ss]tation' AND
	NOT EXISTS (SELECT * FROM page_props WHERE page_id=pp_page AND pp_propname='disambiguation') AND
    (
      	cl_sortkey_prefix='' OR 
        cl_sortkey_prefix REGEXP '^(De|Het|\'t|Els?|Een|The|An?|Les?|La|Los?|L\'|Une?|Der|Die|Das|Eine?) '
    ) AND
	page_title REGEXP '^Station_' AND
    rev_page=page_id AND rev_parent_id=0
GROUP BY page_namespace, page_title, cl_to, cl_sortkey_prefix
ORDER BY page_namespace, page_title, cl_to, cl_sortkey_prefix

SQL

Checking query status...