SQL
AخA
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,"/%")
join page_restrictions subrestrictions on subpage.page_id = subrestrictions.pr_page and subrestrictions.pr_type = "edit"
where source.pr_type="edit" and source.pr_level="sysop" and (basepage.page_namespace = 10 or basepage.page_namespace = 828)
and subrestrictions.pr_level != "sysop";
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.