MariaDB [mediawikiwiki_p]> SELECT
-> rev_user_text, COUNT(*)
-> FROM revision
-> JOIN page
-> ON rev_page = page_id
-> WHERE page_namespace = 1198
-> /* Other filters like page suffix and year
/*> AND page_title LIKE '%/it'*/
-> AND rev_timestamp LIKE '2014%'
-> GROUP BY rev_user_text
-> ORDER BY COUNT(*) DESC
-> LIMIT 50;
+-----------------------+----------+
| rev_user_text | COUNT(*) |
+-----------------------+----------+
| FuzzyBot | 5373 |
| Shirayuki | 4097 |
| MegaAlex | 3056 |
| Fabsouza1 | 1998 |
| John Gordon Reid | 1461 |
| Rundl132 | 1188 |
| Ата | 1064 |
| Meshkov.a | 948 |
| Kaganer | 839 |
| Liuxinyu970226 | 755 |
| Brackenheim | 740 |
| Macofe | 731 |
| Jordi March | 624 |
| Eland Zhou | 587 |
| Chrumps | 562 |
| Varnent | 430 |
| Bene* | 421 |
| WikiPhoenix | 411 |
| Vldandrew | 383 |
| Stryn | 288 |
| Jmarchn | 285 |
| ANBI | 279 |
| Robby | 252 |
| Mormegil | 237 |
| Whym | 226 |
| Imperadeiro98 | 205 |
| Okras | 196 |
| 아라 | 195 |
| Gloria sah | 193 |
| 85.130.71.44 | 191 |
| Binabik155 | 189 |
| JacobRodrigues | 184 |
| 202.171.79.35 | 182 |
| 86.122.241.91 | 181 |
| Amire80 | 180 |
| Jduranboger | 175 |
| WillemBK | 165 |
| יונה בנדלאק | 164 |
| 195.55.176.209 | 163 |
| Suriyaa Kudo | 163 |
| Glykanera | 162 |
| Abani79 | 160 |
| Wifidel | 157 |
| Seb35 | 156 |
| PeppeAeco | 156 |
| Kghbln | 151 |
| GeorgeBarnick | 146 |
| Gryllida | 144 |
| Meno25 | 142 |
| Marmase | 142 |
+-----------------------+----------+
50 rows in set (2.12 sec)