Hewiki templates protection

SQL

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
SQL

Checking query status...
