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
Pppery
.
Toggle Highlighting
SQL
select concat("Category:",page_title),page_len from page join revision on rev_page=page_id and rev_parent_id=0 join category on cat_title=page_title where page_namespace=14 and (page_title like "%Wikipedian%" or page_title like "User%" and cat_pages > 0 and cat_subcats = 0 and not exists (select 1 from categorylinks join page contents on page_id=cl_from where cl_to=cat_title and not (exists (select 1 from templatelinks where tl_from=contents.page_id and tl_namespace=10 and tl_title="Userbox") and (contents.page_namespace != 2 or contents.page_title like "%/%"))) order by rev_timestamp desc;
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...