autism highscore

mysql> select playername,numblocks from `lb-players` join (select count(*) as numblocks,playerid from `lb-int` group by playerid order by numblocks desc limit 20) as actions using (playerid);
+---------------+-----------+
| playername    | numblocks |
+---------------+-----------+
| WaterFlow     |    248681 |
| LavaFlow      |    242322 |
| Koentinius    |    181983 |
| Jam_tin_jack  |    173509 |
| BlakkCooper   |    121557 |
| Striker2117   |    102181 |
| Tangaloa      |     68347 |
| _glo          |     63637 |
| klemen        |     59384 |
| PenOpener     |     58305 |
| peachy_pii    |     48724 |
| Horsti        |     48293 |
| greenkitten   |     44106 |
| MystiaLorelei |     43137 |
| Kopfjaegar    |     42684 |
| kovio         |     42328 |
| villi95       |     42226 |
| Soclokiko     |     38553 |
| Blub_2000AD   |     35324 |
| Enton         |     34966 |
+---------------+-----------+
20 rows in set (0.41 sec)