mysql> select count(id) as num,user from stats group by user order by num desc;
+-----+-------------+
| num | user        |
+-----+-------------+
|  27 | mtwstudios  |
|  13 |             |
|  12 | jtaby       |
|   5 | trilby_dare |
|   3 | twilkcom    |
|   3 | mulka       |
|   3 | DeMarko     |
|   2 | theshaza    |
|   1 | jumpjam     |
+-----+-------------+
9 rows in set (0.01 sec)