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("Module:",page_title),page_len from page where page_namespace=828 and /* not */ exists (select 1 from templatelinks where tl_namespace=page_namespace and tl_title=page_title and tl_from != page_id) /* and page_title not like "%/sandbox" and page_title not like "User:%" and page_title not like "Sandbox/%" and page_title not like "Unicode_data/names/%" */ and page_title like "%andbox%" and page_title not like "%/sandbox" and page_title not like "Sandbox/%" and page_title not like "%testcases%" and page_title not like "User:%" /* */ and page_is_redirect=0 and page_content_model!="wikitext" order by page_title;
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...