nlwiki User pages without a user account

SQL

USE nlwiki_p;
#users: 1.1M SELECT COUNT(user_id) FROM `user`;
/*user pages: 305k SELECT COUNT(page_id) FROM `page` 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]+)?';*/
/*user names with a page: 252k SELECT COUNT(DISTINCT REGEXP_REPLACE(page_title, '/.*$', '')) FROM `page` 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]+)?';*/
SELECT page_namespace, page_title, page_is_redirect
FROM `page`
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,'_',' '), '_*/.*$', '')
               )
SQL

Checking query status...
