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 subpage.page_title from page_restrictions source join page basepage on pr_page=page_id join page subpage on subpage.page_title like concat(basepage.page_title,"/%") and subpage.page_namespace = basepage.page_namespace join page_restrictions subrestrictions on subpage.page_id = subrestrictions.pr_page and subrestrictions.pr_type = "edit" and subpage.page_title not like "%/doc" and subpage.page_title not like "%/sandbox" and subpage.page_title not like "%/testcases" where source.pr_type="edit" and source.pr_level="templateeditor" and (basepage.page_namespace = 10 or basepage.page_namespace = 828) and basepage.page_title != "POTD" and basepage.page_title != "User_wikipedia" and basepage.page_title != "Infobox_road" and subrestrictions.pr_level != "templateeditor" limit 200;
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...