nlwiki Probably missing category sort key

SQL

SELECT 
	page_namespace AS ns, 
    page_title, 
    page_is_redirect AS rd,
    REPLACE(REGEXP_REPLACE(page_title, '_\\(.*\\)$', ''),'_',' ') AS name, 
    cf.cl_to AS cat, 
    cf.commas
FROM page, (
	# fraction of pages in a category having a comma in the sortkey
	SELECT cl_to, (COUNT(*) / (cat_pages-cat_subcats)) AS commas
	FROM categorylinks, category
	WHERE 
  		cat_title!='Vermoord_politicus' AND
  		cat_title NOT REGEXP '^(Adel_|Persoon_in_de_|Wikipedia:)|(bisschop|club)$' AND
		cl_to=cat_title AND
		cl_sortkey_prefix REGEXP ','
	GROUP BY cl_to
	HAVING commas > 0.9 AND commas < 1) cf, categorylinks cl
WHERE 
	NOT EXISTS (SELECT * FROM pagelinks WHERE pl_from=5606063 AND pl_namespace=page_namespace AND pl_title=page_title) AND
	page_id=cl.cl_from AND
    page_title NOT REGEXP '^Paus_|_Brothers$' AND
	page_title REGEXP '^\\p{L}+(_\\p{L}+)+(_\\(.+\\))?$' AND
    page_title NOT REGEXP '^\\p{L}+_[IVX]+_(der|van)_\\p{L}+$' AND
    page_title NOT REGEXP '^\\p{L}+(_\\p{L}+)*_(en|and)_\\p{L}+(_\\p{L}+)*$' AND
    page_title NOT REGEXP '^(Architect|Kampgevangene|Landdrost|Militair|Minister|Persoon|Voorman)_(in|binnen)_' AND
    page_title NOT REGEXP '^('
        'Abt|Admiraal|Admiraliteit|Ambtenaar|Apostolisch_vicaris|'
        'Bestuurder|Bisschop|Bondskanselier|Bondspresident|Burgemeester|Burggraaf|'
        'Campusrector|Commissaris|'
        'Districtsvoorzitter|Domproost|'
        'Forestier|'
        'Gemeenteraadslid|Gedeputeerde|Gevolmachtigd_minister|Gouverneur|Graaf|Grietman|'
        'Heer|Hoofd(redacteur)?|'
        'Kanselier|Keizer|Koning|'
        'Lid|Lijsten|'
        'Markgraaf|Minister|Muziekalbum|'
        'Nummer|'
        'Opperste_directeur|'
    	'Partijvoorzitter|Partner|Pensionaris|Politiek_secretaris|Potestaat|Prefect|Premier|President|'
        'Raadsheer|Raadpensionaris|Ridderschap|Rector_(magnificus_)?|Rechter|'
        'Schepen|Schilder|Schout|Secretaris|Speaker|Stadhouder|Stadsbibliothecaris|'
    	'Vicekanselier|Vicepremier|Voorzitter|'
        'Winnaar)_(van|der)_' AND
    page_title NOT REGEXP '^(Chief_of_|Commandant_|Hoge_commissaris_voor_de_|Hoogleraar_aan_)' AND
    (page_namespace!=14 OR page_title NOT REGEXP '_([a-z]+)$') AND
	cl.cl_to=cf.cl_to AND 
	cl.cl_sortkey_prefix=''
ORDER BY page_latest DESC
SQL

Checking query status...
