قوالب - 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 REGEXP "بذرة|ملعب|شرح|توثيق|css|js"
and p.page_namespace = 10
and t.tl_from_namespace = 0
and t.tl_namespace = 10
GROUP BY p.page_title
having Interlanguage < 10
SQL

Checking query status...
