select replace(template, '_', ' ') as template, counter as transclusions,

    if(id = -1, 'redlink', ifnull(pr_level, 'none')) as protection,

    if(pr_level in ('sysop', 'templateeditor'), '', '!!!') as problem 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) desc) 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'

where counter >= 1000

​