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 * FROM user LIMIT 10;
SELECT * FROM actor LIMIT 10;
/*SELECT 
	page_namespace, 
    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...