select template, counter, if(id = -1, 'fgh', ifnull(pr_level, 'none')) as protection from

(select template, counter, ifnull(page_id, -1) 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 left join page

 on page_namespace = 10

 and page_title = template) t1 left join page_restrictions

on pr_page = id

and pr_type = 'edit'

​