MariaDB [metawiki_p]> SELECT log_user_text, COUNT(*) FROM logging WHERE log_type = 'pagetranslation' AND log_timestamp > 20130101000000 GROUP BY log_user_text ORDER BY COUNT(*) DESC LIMIT 25; +------------------+----------+ | log_user_text | COUNT(*) | +------------------+----------+ | Verdy p | 3121 | | Varnent | 1991 | | Ата | 938 | | Steinsplitter | 804 | | Chrumps | 389 | | Nemo bis | 373 | | PiRSquared17 | 326 | | Kaganer | 318 | | Odder | 304 | | Jalexander | 268 | | Base | 266 | | Siebrand | 243 | | Guillom | 228 | | Ralgis | 220 | | Tbayer (WMF) | 203 | | Thehelpfulone | 189 | | MF-Warburg | 189 | | Jon Harald Søby | 184 | | Jean-Frédéric | 166 | | Vogone | 90 | | Rillke | 90 | | Bdamokos | 87 | | Haithams | 86 | | Philippe (WMF) | 69 | | Jmorgan (WMF) | 64 | +------------------+----------+ 25 rows in set (0.04 sec)