Advertisement
Guest User

Untitled

a guest
Oct 30th, 2014
199
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.36 KB | None | 0 0
  1. mysql> select match_id, radiant_score, dire_score, radiant_team, dire_team, radiant_score + dire_score as kills from mtch where match_id != 785923491 and date > "2014-01-01" order by kills desc limit 10;
  2. +-----------+---------------+------------+--------------+-----------------+-------+
  3. | match_id | radiant_score | dire_score | radiant_team | dire_team | kills |
  4. +-----------+---------------+------------+--------------+-----------------+-------+
  5. | 610497965 | 80 | 60 | 4FC | DOG | 140 |
  6. | 983011211 | 70 | 51 | aShock | KPG | 121 |
  7. | 928267278 | 59 | 59 | coL 2 | SNA 4 | 118 |
  8. | 979930266 | 69 | 46 | TEAMnxl | MVP Phoenix | 115 |
  9. | 649985663 | 48 | 64 | ISG | uG | 112 |
  10. | 823753754 | 42 | 69 | Arrow | SCYTHE 2 | 111 |
  11. | 954474956 | 61 | 50 | NEXT.kz | M5 | 111 |
  12. | 901737694 | 55 | 55 | Nb | VG | 110 |
  13. | 781106732 | 44 | 65 | Arcanys | First Departure | 109 |
  14. | 669978153 | 54 | 55 | New Elements | CIS | 109 |
  15. +-----------+---------------+------------+--------------+-----------------+-------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement