Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select CONCAT(firstname," ",surname), goldstars, blames, goldstars - blames as karma from shbot_user order by karma desc;
- +-------------------------------+-----------+--------+-------+
- | CONCAT(firstname," ",surname) | goldstars | blames | karma |
- +-------------------------------+-----------+--------+-------+
- | Johnny Thow | 326 | 66 | 260 |
- | David Pinkerton | 243 | 32 | 211 |
- | Andrew Hendry | 270 | 87 | 183 |
- | Colin Jack | 421 | 310 | 111 |
- | Steven Hammerton | 235 | 147 | 88 |
- | Rao_Dao Zao | 163 | 78 | 85 |
- | Inti Herteleer | 52 | 7 | 45 |
- | Zooey Deschanel | 30 | 0 | 30 |
- | ShbotV2 | 60 | 30 | 30 |
- | Jebus Banga | 24 | 5 | 19 |
- | Gee Chand | 21 | 3 | 18 |
- | Dot | 25 | 8 | 17 |
- | That Guy | 22 | 5 | 17 |
- | Ali Osman | 12 | 1 | 11 |
- | Mohammed Osman | 11 | 0 | 11 |
- | Calum Munro | 6 | 2 | 4 |
- | Christophle McCluskers | 5 | 1 | 4 |
- | cake | 3 | 0 | 3 |
- | Google | 7 | 4 | 3 |
- | Mike Childs | 3 | 0 | 3 |
- | Josh | 2 | 0 | 2 |
- | wiki pedia | 2 | 0 | 2 |
- | Andrew McLatchie | 2 | 0 | 2 |
- | Ioannis Valatsos | 2 | 0 | 2 |
- | Adrian Stace | 2 | 0 | 2 |
- | earth lion | 1 | 0 | 1 |
- | daft punk | 1 | 0 | 1 |
- | James MacIver | 1 | 0 | 1 |
- | svn | 0 | 0 | 0 |
- | maven | 0 | 0 | 0 |
- | Mozilla Foundation | 1 | 1 | 0 |
- | Eclipse | 2 | 2 | 0 |
- | Apple | 2 | 2 | 0 |
- | Zune | 0 | 0 | 0 |
- | us lot | 0 | 0 | 0 |
- | Amor | 3 | 3 | 0 |
- | WolframAlpha | 31 | 32 | -1 |
- | Public Sector | 0 | 1 | -1 |
- | Kana Ciboodle | 0 | 1 | -1 |
- | groove shark | 1 | 4 | -3 |
- | David Anderson | 11 | 15 | -4 |
- | UrbanDictionary | 89 | 94 | -5 |
- | Handy Fergy | 6 | 14 | -8 |
- | VisualStudio | 2 | 13 | -11 |
- | Microsoft | 16 | 46 | -30 |
- | Sword | 4 | 37 | -33 |
- | Thomas Lightbody | 688 | 1225 | -537 |
- +-------------------------------+-----------+--------+-------+
Add Comment
Please, Sign In to add comment