Articles with the most clean-up tags (arwiki)

Fork of Articles with the most clean-up tags (lvwiki) by Edgars2007

This query is marked as a draft This query has been published by FShbib.

SQL

USE arwiki_p;
SELECT #page_title, tl_title
p.page_title, COUNT(t.tl_title)
FROM templatelinks t
join page p on p.page_id = t.tl_from
INNER JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to = 'جميع_المقالات_التي_بحاجة_لصيانة'
where t.tl_namespace = 10 AND t.tl_title IN ("يتيمة" ,"مصدر", "نهاية_مسدودة", "وصلات_قليلة", "دمج", "غير_مصنفة", "تفخيم", "حيادية")
		and tl_from_namespace=0 and page_is_redirect=0
GROUP BY p.page_title
ORDER BY COUNT(t.tl_title) DESC
LIMIT 300

SQL

Checking query status...