Most used autotranslate non-Translate templates on Commons

Fork of Most used autotranslate non-Translate templates on Commons by SacredWKnight

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

To be migrated: https://commons.wikimedia.org/wiki/Help:Autotranslate#Using_Extension:Translate

SQL

USE commonswiki_p;
SELECT tl_title, COUNT(*)
FROM templatelinks
JOIN page
ON page_title = tl_title
AND page_namespace = 10
AND tl_namespace = 10
JOIN categorylinks a
ON page_id = a.cl_from
AND a.cl_to = 'Autotranslated_templates'
LEFT JOIN categorylinks b
ON a.cl_from = b.cl_from
AND b.cl_to = 'Templates_using_the_Translate_extension_for_internationalisation'
WHERE b.cl_to IS NULL
GROUP BY tl_title
ORDER BY COUNT(*) DESC
-- HAVING COUNT(*) > 1000
LIMIT 100;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...