SQL
AخA
SELECT page_namespace AS ns, page_title
FROM page
WHERE
page_is_redirect=0 AND
page_title REGEXP '_\\(schip,_|^(HMS|Hr\\.Ms\\.|[MP][0-9]+|USS|Zr\\.Ms\\.)_.*_\\([0-9]+\\)$' AND
NOT EXISTS (SELECT * FROM categorylinks WHERE cl_to REGEXP '[Ss]chip_op_naam$' AND cl_from=page_id)
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.