Advertisement
Guest User

autism highscore

a guest
Jul 14th, 2012
76
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None
  1. 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);
  2. +---------------+-----------+
  3. | playername | numblocks |
  4. +---------------+-----------+
  5. | WaterFlow | 248681 |
  6. | LavaFlow | 242322 |
  7. | Koentinius | 181983 |
  8. | Jam_tin_jack | 173509 |
  9. | BlakkCooper | 121557 |
  10. | Striker2117 | 102181 |
  11. | Tangaloa | 68347 |
  12. | _glo | 63637 |
  13. | klemen | 59384 |
  14. | PenOpener | 58305 |
  15. | peachy_pii | 48724 |
  16. | Horsti | 48293 |
  17. | greenkitten | 44106 |
  18. | MystiaLorelei | 43137 |
  19. | Kopfjaegar | 42684 |
  20. | kovio | 42328 |
  21. | villi95 | 42226 |
  22. | Soclokiko | 38553 |
  23. | Blub_2000AD | 35324 |
  24. | Enton | 34966 |
  25. +---------------+-----------+
  26. 20 rows in set (0.41 sec)
Advertisement
RAW Paste Data Copied
Advertisement