From 256ef079b112b288c5b23f7c0b42d099eb9be807 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Sun, 22 Oct 2017 15:55:52 +0200
Subject: add item & surrender columns to pp

---
 crunch_player.sql | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

(limited to 'crunch_player.sql')

diff --git a/crunch_player.sql b/crunch_player.sql
index 41809f1..30b1742 100644
--- a/crunch_player.sql
+++ b/crunch_player.sql
@@ -35,7 +35,9 @@ select
     sum(p_s.kraken_captures) as kraken_captures,
     sum(p_s.turret_captures) as turret_captures,
     sum(p_s.gold) as gold,
-    sum(p_s.impact_score) as impact_score
+    sum(p_s.impact_score) as impact_score,
+    sum(p_i.surrender) as surrender,
+    _p_i_item_uses_insert
 from participant p
 join participant_stats p_s on (p_s.participant_api_id = p.api_id)
 left outer join participant_items p_i on (p_i.participant_api_id = p.api_id)
@@ -74,4 +76,6 @@ gold_mine_captures = gold_mine_captures + values(gold_mine_captures),
 kraken_captures = kraken_captures + values(kraken_captures),
 turret_captures = turret_captures + values(turret_captures),
 gold = gold + values(gold),
-impact_score = impact_score + values(impact_score)
+impact_score = impact_score + values(impact_score),
+surrender = surrender + values(surrender),
+_p_i_item_uses_update
-- 
cgit v1.3.1

