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

AخA
 
SELECT
    page_namespace AS ns, page_title, rev_timestamp AS 'created',
    GROUP_CONCAT(REPLACE(cl_to,'_',' ') SEPARATOR ' | ') AS cl_to
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 '^Station [\'ADEHLTU]'
    ) AND
    page_title REGEXP '^Station_(De|Het|\'t|Els?|Een|The|An?|Les?|La|Los?|L\'|Une?|Der|Die|Das|Eine?)_\\p{L}' AND
    #page_title NOT REGEXP '^(\'t|Het)_([Bb]egon|[Bb]lijft|[Bb]randt|[Hh]eeft|[Ii]s|[Kk]an|[Rr]egent|[Ww]erd|[Zz]ijn|[Zz]omert)_' AND
    rev_page=page_id AND rev_parent_id=0
GROUP BY page_namespace, page_title
ORDER BY page_namespace, page_title
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...