HWBOT popularity ranking

[richba5tard]

One week after the ability to vote for a submission has been released, it's time for a preliminary popularity ranking.

 

mysql> select sum(result.votes) votes, user.name from result join user using (user_id) group by user_id having votes > 0 order by votes desc limit 20;
+-------+---------------+
| votes | name          |
+-------+---------------+
|    55 | AndreYang     | 
|    52 | NickShih      | 
|    41 | k|ngp|n       | 
|    27 | hipro5        | 
|    21 | GraduS        | 
|    18 | D'n'B         | 
|    16 | stummerwinter | 
|    10 | demios        | 
|     9 | Benji Tshi    | 
|     8 | jmax_oc       | 
|     7 | Matti OC      | 
|     6 | Qartweli      | 
|     6 | dinos22       | 
|     5 | angoholic     | 
|     5 | SF3D          | 
|     5 | GutterZ       | 
|     5 | TinTin@OCQQ   | 
|     4 | Dualist       | 
|     4 | packet        | 
|     4 | road-runner   | 
+-------+---------------+
20 rows in set (1.44 sec)

 

Congrats AndreYang! :woot: