select template, counter, pr_level 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) t join page right join page_restrictions

on page_namespace = 10

and page_title = template

and pr_page = page_id

where pr_type = 'edit'

 /*

select * from page_restrictions join page

on pr_page = page_id

where pr_type = 'edit'

limit 10

*/