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.