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'