Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Erutuon
.
User and user talk pages and subpages where the base page name doesn't look like an IP address and isn't a username.
Toggle Highlighting
SQL
use enwiktionary_p; select * 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(regexp_replace(page_title, "/.*", ""), "_", " ") as potential_user_name, page_is_redirect as is_redirect from page where page_namespace = 2 and page_title like "%/%" limit 1000) as user_subpage where potential_user_name not rlike '^[0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}$' and potential_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_name = potential_user_name limit 1);
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...