قوالب - Quarry

SQL

select  p.page_id,concat("[[قالب:",REPLACE(p.page_title,"_"," "),"]]") as name,COUNT( t.tl_title) AS Total,COUNT(distinct l.ll_lang) AS Interlanguage
from page p 
LEFT JOIN templatelinks t ON t.tl_title = p.page_title  
LEFT JOIN langlinks l ON l.ll_from = p.page_id 
where p.page_title REGEXP "معلومات|صندوق|شخصية|ص\.م"
and p.page_title not like "%/%" 
and p.page_namespace = 10
and t.tl_from_namespace = 0
and t.tl_namespace = 10
and COUNT( t.tl_title) <= 10
GROUP BY p.page_title
SQL

Checking query status...
