Subpages possibly in need protection (TE)

SQL

select subpage.page_namespace, 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;
SQL

Checking query status...
