User:SQL/Toprev

Top 50 enws reverters!

mysql> select count(*),rev_user_text from revision where rev_comment LIKE "Reverted changes by%" OR rev_comment = "rvv" GROUP BY rev_user_text order by count(*) DESC LIMIT 50; +--+--+ +--+--+ +--+--+ 50 rows in set (3.32 sec)
 * count(*) | rev_user_text   |
 * 1019 | Jayvdb          |
 * 305 | Yann            |
 * 289 | Pathoschild     |
 * 267 | BirgitteSB      |
 * 204 | Newmanbe        |
 * 196 | Zhaladshar      |
 * 195 | Bookofjude      |
 * 180 | Sherurcij       |
 * 120 | Tarmstro99      |
 * 115 | Shanel          |
 * 86 | ThomasV         |
 * 67 | Danny           |
 * 66 | GrafZahl        |
 * 47 | Guillom         |
 * 40 | FloNight        |
 * 40 | Mattwj2002      |
 * 39 | Sanbeg          |
 * 31 | Az1568          |
 * 30 | Eclecticology   |
 * 29 | Cowardly Lion   |
 * 21 | Illy            |
 * 16 | Spacebirdy      |
 * 10 | Spangineer      |
 * 7 | SCEhardt        |
 * 7 | AllanHainey     |
 * 6 | Quillercouch    |
 * 6 | Raul654         |
 * 6 | Politicaljunkie |
 * 6 | Quadell         |
 * 3 | Dark journey    |
 * 3 | Rschen7754      |
 * 3 | Nicknack009     |
 * 3 | Jusjih          |
 * 2 | Stbalbach       |
 * 2 | DarkFalls       |
 * 2 | Tetraminoe      |
 * 2 | Kathleen.wright5 |
 * 2 | Smee            |
 * 2 | Hesperian       |
 * 2 | Aleator         |
 * 2 | Hut 8.5         |
 * 2 | MaxSem          |
 * 1 | 24.83.203.198   |
 * 1 | Amgine          |
 * 1 | MeekSaffron     |
 * 1 | 62.140.253.8    |
 * 1 | InvisibleSun    |
 * 1 | Swift           |
 * 1 | Andre Engels    |
 * 1 | Mtmelendez      |