Untitled query #47677

SQL

use hywiki_p;

select
	id,
    ns,
    title,
    concat(if(ns = 2, "User", "User_talk"), ":", title) as full_title,
    len
from (select
        page_id as id,
        page_namespace as ns,
        page_title as title,
        page_content_model = 'wikitext',
        page_len as len,
        replace(regexp_replace(page_title, "/.*", ""), "_", " ") as user_name,
        page_is_redirect = 0
      from page 
      where page_namespace = 2
      	or page_namespace = 3)
      as user_subpage
where
	user_name not rlike '^[0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}$'
    and user_name not rlike '(^([0-9]{1,3}[.]){3}[0-9]{1,3}$|^([[:alnum:]]{1,4}[:]){7})'
    and not exists (select 1 from user where user.user_name = user_subpage.user_name limit 1);
SQL

Checking query status...
