use hewiki_p;

select page_namespace, page_title from page as p0

where page_restrictions like "%edit=sysop%"

or page_restrictions like "%edit=templateeditor%"

or exists

(select * from page_restrictions

where page_id = pr_page

and pr_type = "edit"

and (pr_level = "sysop"

     or pr_level = "templateeditor"))

​