nlwiki Ship article with missing ship-category

SQL

SELECT page_title, REGEXP_REPLACE(REPLACE(page_title,'_',' '), 
	'^([A-Z]+[0-9]*|[HZ]r\\.Ms\\.) (.*) \\(.*$', '\\2') AS 'generated-catsort', pp_value AS defaultsort
FROM page LEFT JOIN page_props ON page_id=pp_page AND pp_propname='defaultsort'
WHERE
	page_namespace=0 AND
    page_is_redirect=0 AND
    page_title REGEXP 
    	'_\\(schip,_|^([AFMP][0-9]+|ARA|CSS|HMA[SV]|HMHS|HM[SY]|[HZ]r\\.Ms\\.|MOV|O_[0-9]+|SMS|USNS|USRC|USS)_.*_\\([0-9]+\\)$' AND
    NOT EXISTS (SELECT * FROM categorylinks WHERE cl_to REGEXP '[Ss]chip_op_naam$' AND cl_from=page_id)
ORDER BY page_title
    
# query to discover navy prefixes
/*SELECT page_title
FROM page, categorylinks
WHERE page_namespace=0 AND page_is_redirect=0 AND page_title REGEXP '_\\([0-9]+\\)$' AND 
	cl_from=page_id AND cl_to REGEXP '[Ss]chip_op_naam$' AND
	page_title NOT REGEXP '^([AFMP][0-9]+|ARA|CSS|HMA[SV]|HMHS|HM[SY]|[HZ]r\\.Ms\\.|MOV|O_[0-9]+|SMS|USNS|USRC|USS)_'
ORDER BY page_title
LIMIT 100*/
SQL

Checking query status...
