Articles with the most clean-up tags (lvwiki)

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 
#concat('|[[',p.page_title,']]')
p.page_title, COUNT(t.tl_title)
FROM page p
JOIN pagelinks pl ON pl.pl_title=p.page_title and pl.pl_namespace=0 and pl.pl_from=293448
#INNER JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to = 'Visi_Vikipēdijas_uzlabojamie_raksti'
LEFT JOIN templatelinks t ON p.page_id = t.tl_from AND t.tl_namespace = 10 AND t.tl_title IN ("يتيمة","نهاية_مسدودة","مصدر","ملحوظية")
GROUP BY p.page_title
ORDER BY COUNT(t.tl_title) DESC
LIMIT 100;

SQL

Checking query status...