nlwiki User pages without a user account

(anonymous users and redirects excluded)

Note that the table `user` doesn't seem to contain entries for users with zero visible edits (and neither does `actor`).

SQL

SELECT page_namespace AS ns, REPLACE(page_title,'_',' ') AS page_title, GROUP_CONCAT(REPLACE(cl_to,'_',' ') SEPARATOR ' | ') AS cl_to
FROM `page` LEFT JOIN `categorylinks` ON page_id=cl_from
WHERE 
	page_is_redirect=0 AND
	page_namespace IN (2, 3) AND
    page_title NOT REGEXP '([1-9][0-9\.]+[0-9]|[1-9A-F][0-9A-F:]+[0-9A-F])(/[0-9]+)?' AND
    NOT EXISTS (SELECT * FROM `user` WHERE user_name=REGEXP_REPLACE(REPLACE(page_title,'_',' '), ' */.*$', ''))
GROUP BY page_latest
ORDER BY page_latest DESC	# latest edits on top

SQL

Checking query status...