Fork of
Number of translators in mw.org per language who have made at least 100 edits in the last 360 days
by Elitre (WMF)
This query is marked as a draft
This query has been published
by Elitre (WMF).
SQL
x
use mediawikiwiki_p;SELECT lang, count(*) as no_translators FROM (SELECT substring_index(page_title, '/', -1) as lang,rev_user_text,count(page_id) as count FROM `page` JOIN `revision` ON ((page_id=rev_page)) WHERE (page_title LIKE '%/%' ESCAPE '`' ) AND page_namespace IN ('1198') AND (rev_timestamp > now() - INTERVAL 360 DAY + 0) AND (rev_user_text not in ('FuzzyBot')) GROUP BY rev_user_text,lang HAVING count > 100 ORDER BY NULL) AS sub GROUP BY lang HAVING no_translators >= 5 ORDER BY no_translators DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.