Userspace pages of non-existent users

SQL

SELECT CONCAT("https://en.wikipedia.org/wiki/User:", p.page_title)
FROM enwiki_p.page p
INNER JOIN enwiki_p.categorylinks cl ON p.page_id = cl.cl_from
LEFT JOIN enwiki_p.user u ON REPLACE(SUBSTRING_INDEX(p.page_title, '/', 1), '_', ' ') = u.user_name
WHERE page_namespace = 2
AND u.user_id IS NULL
AND p.page_is_redirect = 0
AND p.page_title NOT LIKE '%.%.%.%'
AND p.page_title NOT LIKE '%:%:%:%:%:%:%:%'
AND p.page_title NOT LIKE '%.css'
AND p.page_title NOT LIKE '%.cs'
AND p.page_title NOT LIKE '%.js'
AND p.page_title NOT LIKE '%.charset'
AND cl.cl_to != 'User_soft_redirects'
AND cl.cl_to != 'Wikipedia_doppelganger_accounts'
SQL

Checking query status...
