select template, counter, pr_level from

(select template, counter, page_id as id from

(select tl_title as template, count(tl_from) as counter from templatelinks

 where tl_from_namespace = 0

 and tl_namespace = 10

 group by tl_title

 order by count(tl_from) asc

 limit 100) t0 join page

 on page_namespace = 10

 and page_title = template) t1 left join page_restrictions

on pr_page = id

where pr_type = 'edit'

​