nlwiki Ship article with missing ship-category

SQL

SELECT page_namespace AS ns, page_title, REGEXP_REPLACE(page_title, 
	'^([AFMP][0-9]+|ARA|CSS|HMA[SV]|HMHS|HM[SY]|[HZ]r\\.Ms\\.|MOV|O_[0-9]+|SMS|USNS|USRC|USS)_(.*)_\\([0-9]+\\)$', '$2') AS catsort
FROM page
WHERE
	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 ns, page_title
    
# query to discover navy prefixes
/*SELECT page_title
FROM page, categorylinks
WHERE 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...
