SQL
AخA
SELECT 'https://en.wikipedia.org/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 REPLACE(SUBSTRING_INDEX(p.page_title, '/', 1), '_', ' ') NOT LIKE '%.%.%.%'
AND REPLACE(SUBSTRING_INDEX(p.page_title, '/', 1), '_', ' ') NOT LIKE '%:%:%:%:%:%:%:%'
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.