From 115b84b82063fe6d66f10f2d8469a46f6c678f9a Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Wed, 5 Jul 2017 16:49:34 +0200
Subject: fix player point column order

---
 crunch_player.sql | 13 +++++++------
 1 file changed, 7 insertions(+), 6 deletions(-)

(limited to 'crunch_player.sql')

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`,
-- 
cgit v1.3.1

