nlwiki Anomalous sort key for main article of category

SQL

SELECT 
	REPLACE(a.page_title,'_',' ') AS title, 
    a.page_is_redirect AS redir,
	cl_sortkey_prefix AS sortkey,
    LENGTH(cl_sortkey_prefix) AS 'length',
    a.page_id AS 'a.page_id',
    c.page_id AS 'c.page_id',
    a.page_latest,
    cat_pages AS '#cat'
FROM 
	page a
    INNER JOIN page c ON a.page_title=c.page_title
    INNER JOIN category ON c.page_title=cat_title
	LEFT JOIN categorylinks ON (a.page_id=cl_from AND c.page_title=cl_to)
WHERE
	a.page_namespace=0 AND
	c.page_namespace=14 AND
	(LENGTH(cl_sortkey_prefix)=0 OR LEFT(cl_sortkey_prefix, 1) NOT IN (' ', '*')) AND
    cat_pages>2
ORDER BY a.page_latest DESC

SQL

Checking query status...