Redirects in userspaces of non-existent users (no subpages)

This excludes redirects to pages in the userspace, most of which are likely valid and created after a user has been renamed.  Also excluded are redirects to the project space.

SQL

SELECT CONCAT('https://en.wikipedia.org/wiki/User:', p.page_title) AS URL
FROM enwiki_p.page p
LEFT JOIN enwiki_p.user u ON REPLACE(p.page_title, '_', ' ') = u.user_name
INNER JOIN enwiki_p.redirect rd ON p.page_id = rd.rd_from AND rd.rd_namespace NOT IN (2, 3)
WHERE p.page_namespace = 2
AND u.user_id IS NULL
AND p.page_is_redirect = 1
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 LIKE '%/%'

SQL

Checking query status...