Replicas browser and optimizer
User pages of non-existent users
This query is marked as a draft
This query has been published
(This should in theory show all subpages and also show, if some of these are redirects, where they go (and perhaps exclude those whose targets are user pages of actual users.)
USE etwiki_p; SELECT concat("kasutaja:", page_title) FROM page WHERE page_title REGEXP '^[^/]+$' AND page_namespace=2 AND replace(page_title, '_', ' ') NOT IN (select user_name from user) LIMIT 10;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in