Translators at meta with language, number of translations

For a given prefix of translatable pages, take all translators for the latest versions of translation units (otherwise someone fixing their own typos would look a prolific translator) and order them by language and translation volume.

SQL

use ltwiki_p;

SELECT
	actor_name as user,
	substring_index(page_title, '/', -1) AS language,
	count(*) AS no_edits,
    CONCAT('* {{target | page = User:', actor_name, ' | site = https://lt.wikipedia.org/wiki/Specialus:ContentTranslation')  AS url
FROM
	page
LEFT JOIN
	-- Take only the latest revision of each translation to simplify
	revision ON (page_id = rev_page AND page_latest = rev_id)
LEFT JOIN
	actor_revision ON (rev_actor = actor_id)    
WHERE
	page_namespace = 1198
    AND
    rev_timestamp > (now() - INTERVAL 90 DAY + 0)   
GROUP BY
	user, language
HAVING
    no_edits > 5
ORDER BY
	language, no_edits DESC;

SQL

Checking query status...