SELECT CONCAT("https://en.wikipedia.org/wiki/User:", p.page_title)

FROM enwiki_p.page p

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 p.page_id NOT IN (

    SELECT cl.cl_from

    enwiki_p.categorylinks cl

    WHERE cl.cl_to = 'Wikipedia_doppelganger_accounts'

)