use commonswiki_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;