MariaDB [commonswiki_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 15; +-----------------+----------+ | log_user_text | COUNT(*) | +-----------------+----------+ | Steinsplitter | 486 | | Rillke | 354 | | Jean-Frédéric | 291 | | Mono | 226 | | Lokal Profil | 63 | | Kelson | 61 | | BaseSat | 43 | | Varnent | 35 | | Whym | 33 | | Chrumps | 32 | | Vogone | 28 | | 80686 | 28 | | Kwj2772 | 27 | | Pleclown | 24 | | Jarekt | 23 | +-----------------+----------+ 15 rows in set (0.03 sec)