Subpages possibly in need protection (TE)

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,"/%")
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="sysop" and (basepage.page_namespace = 10 or basepage.page_namespace = 828)
and subrestrictions.pr_level != "sysop";

SQL

Checking query status...