ckb: Pages of non-existent users that redirect outside userspace

SQL

SELECT CONCAT('https://ckb.wikipedia.org/w/index.php?title=User', CASE WHEN p.page_namespace = 3 THEN '_talk:' ELSE ':' END, p.page_title, '&redirect=no') AS URL
FROM ckbwiki_p.page p
LEFT JOIN ckbwiki_p.user u ON REPLACE(SUBSTRING_INDEX(p.page_title, '/', 1), '_', ' ') = u.user_name
INNER JOIN ckbwiki_p.pagelinks pl ON p.page_id = pl.pl_from AND pl.pl_namespace NOT IN (2, 3)
WHERE p.page_namespace IN (2, 3)
AND u.user_id IS NULL
AND p.page_is_redirect = 1
AND NOT IS_IPV4(SUBSTRING_INDEX(p.page_title, '/', 1)) -- Exclude IPv4
AND NOT IS_IPV6(SUBSTRING_INDEX(p.page_title, '/', 1)) -- Exclude IPv6

SQL

Checking query status...