Commons:Pronunciation recording/Wiktionary statistics

Obtaining data

Data were taken from Labs using the following query:

SELECT CONVERT(rc_user_text USING utf8) AS user_name, count(*) AS edit_count
FROM frwiktionary_p.recentchanges
WHERE (NOT rc_user_text LIKE '%Bot%') AND (NOT rc_user_text LIKE '%bot%') AND (rc_bot = 0)
GROUP BY rc_user ORDER BY edit_count DESC;