use hewiki_p;

select distinct(page_namespace) from page

where (page_restrictions like "%=sysop%")

or (page_restrictions like "%=templateeditor%")

or exists

(select * from page_restrictions

where page_id = pr_page

and (pr_level = "sysop"

or pr_level = "templateeditor"))

​