Most used WP banners (arwiki)

SQL

USE arwiki_p;
SELECT  CONCAT('# [[:قالب:',page_title,']]'), COUNT(tl_from) AS uses
FROM page
LEFT JOIN templatelinks ON tl_title = page_title AND tl_namespace = page_namespace
WHERE page_namespace = 10 and page_is_redirect=0
AND page_title REGEXP 'مشروع_ويكي_'
AND page_title NOT LIKE '%/%'
AND page_title NOT LIKE 'شريط_مشروع_ويكي_ورائي'
AND page_title NOT LIKE 'ترحيب%'
AND page_title NOT LIKE 'دعوة%'
AND page_title NOT LIKE 'مستخدم%'
AND page_title NOT LIKE 'قسم_مشروع_ويكي_فرعي%'
GROUP BY page_title
ORDER BY uses, page_is_redirect, page_title;
SQL

Checking query status...
