Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
- +-----------+---------------+------------+--------------+-----------------+-------+
- | match_id | radiant_score | dire_score | radiant_team | dire_team | kills |
- +-----------+---------------+------------+--------------+-----------------+-------+
- | 610497965 | 80 | 60 | 4FC | DOG | 140 |
- | 983011211 | 70 | 51 | aShock | KPG | 121 |
- | 928267278 | 59 | 59 | coL 2 | SNA 4 | 118 |
- | 979930266 | 69 | 46 | TEAMnxl | MVP Phoenix | 115 |
- | 649985663 | 48 | 64 | ISG | uG | 112 |
- | 823753754 | 42 | 69 | Arrow | SCYTHE 2 | 111 |
- | 954474956 | 61 | 50 | NEXT.kz | M5 | 111 |
- | 901737694 | 55 | 55 | Nb | VG | 110 |
- | 781106732 | 44 | 65 | Arcanys | First Departure | 109 |
- | 669978153 | 54 | 55 | New Elements | CIS | 109 |
- +-----------+---------------+------------+--------------+-----------------+-------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement