SELECT CONCAT('https://te.wikipedia.org/wiki/User:', p.page_title) AS URL

FROM tewiki_p.page p

LEFT JOIN tewiki_p.user u ON REPLACE(p.page_title, '_', ' ') = u.user_name

WHERE p.page_namespace = 2

AND u.user_id IS NULL

AND p.page_is_redirect = 0

AND NOT IS_IPV4(p.page_title) -- Exclude IPv4

AND NOT IS_IPV6(p.page_title) -- Exclude IPv6

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_title NOT LIKE '%.%.%.xxx'

AND p.page_title NOT IN ('Unknown_user', 'Global_rename_script', 'Sec\"\'27\\u00226\\x3ETest_(WMF)') -- Exclude technical user pages

AND p.page_title NOT LIKE '%/%'