diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-07-05 16:49:34 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-07-05 16:49:34 +0200 |
| commit | 115b84b82063fe6d66f10f2d8469a46f6c678f9a (patch) | |
| tree | e0cf2604df0beb4e3a36803f63de9fee499795a2 | |
| parent | 2be09e2ce40e60a452d865fbec6cd969c29ea42a (diff) | |
| download | cruncher-115b84b82063fe6d66f10f2d8469a46f6c678f9a.tar.gz cruncher-115b84b82063fe6d66f10f2d8469a46f6c678f9a.zip | |
fix player point column order
| -rw-r--r-- | crunch_player.sql | 13 |
1 files changed, 7 insertions, 6 deletions
diff --git a/crunch_player.sql b/crunch_player.sql index 81af4a1..49570c6 100644 --- a/crunch_player.sql +++ b/crunch_player.sql @@ -3,17 +3,18 @@ SELECT NULL, `participant`.`player_api_id`, - COUNT(`participant`.`id`) AS `played`, - SUM(CAST(`participant`.`winner` AS INT)) AS `wins`, - SUM(`duration`) AS `time_spent`, - `series`.`id`, - `role`.`id`, `filter`.`id`, `hero`.`id`, `game_mode`.`id`, - `participant`.`created_at`, + `role`.`id`, + COUNT(`participant`.`id`) AS `played`, + SUM(CAST(`participant`.`winner` AS INT)) AS `wins`, + SUM(`duration`) AS `time_spent`, + + `participant`.`created_at`, + SUM(`participant_stats`.`kills`) AS `kills`, SUM(`participant_stats`.`deaths`) AS `deaths`, SUM(`participant_stats`.`assists`) AS `assists`, |