Most usage flag templates

SQL

SELECT 
concat('[[قالب:',lt_title,']]'), 
concat('[[قالب:',lt_title,'/ملعب]]'),
concat('[[قالب:',lt_title,'/مختبر]]'),
count(*) as a
FROM templatelinks, linktarget, page
where lt_namespace = 10 
and tl_target_id = lt_id
and tl_from_namespace = 0
and page_title = lt_title
and page_namespace = lt_namespace
and lt_title not like "%/%"
and page_id in (select cc.cl_from from categorylinks cc where cc.cl_to = "قوالب_تنسيق_قوالب_الأعلام")
group by lt_title
order by COUNT(lt_title) desc
limit 150;
SQL

Checking query status...
