Ownerless user and user talk pages

SQL

select
	id,
    ns,
    title,
    -- concat(if(ns = 2, "User", "User_talk"), ":", title) as full_title,
    content_model,
    len,
    rd_namespace as redirect_target_namespace,
    rd_title as redirect_target_title
from (select
        page_id as id,
        page_namespace as ns,
        page_title as title,
        page_content_model as content_model,
        page_len as len,
        replace(substring_index(page_title, "/", 1), "_", " ") as user_name,
        rd_namespace,
      	rd_title
      from page
      left join redirect on rd_from = page_id
      where page_namespace in (2, 3)
     ) as user_subpage
where
	user_name not rlike '^([0-9]{1,3}[.]){3}[0-9]{1,3}$|^([0-9A-F]{1,4}:){7}[0-9A-F]{1,4}$'
    and not exists (select 1 from user where user.user_name = user_subpage.user_name limit 1);
SQL

Checking query status...
