Untitled query #66556

SQL

USE arwiki_p;
SELECT CONCAT('[[قالب:',page_title,']]') AS "القالب", COUNT(tl_from) AS "عدد الاستخدام", SUM(IF(tl_from_namespace = 0, 1, 0)) AS "نطاق المقالات", page_is_redirect
FROM page
LEFT JOIN templatelinks ON tl_title = page_title AND tl_namespace = page_namespace
WHERE page_namespace = 10
#AND page_title LIKE "بذرة%"
AND page_title NOT LIKE "%/%"
AND page_is_redirect = 1
#and page_id in (select tl_from from templatelinks  where tl_title = 'بذرة') 
#and page_id not in (select tl_from from templatelinks  where tl_title = 'صندوق_رسالة_بذرة') 
GROUP BY page_title
ORDER BY "نطاق المقالات", "عدد الاستخدام", page_is_redirect, page_title
#Limit 10;
SQL

Checking query status...
