From 6c6826ab1811652f3391089c128592658a1cf784 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Wed, 23 Aug 2017 21:11:01 +0200
Subject: use flat item_use columns, drop dynamic col aggregates

---
 crunch_global.sql | 10 ++--------
 1 file changed, 2 insertions(+), 8 deletions(-)

(limited to 'crunch_global.sql')

diff --git a/crunch_global.sql b/crunch_global.sql
index 8d618ce..2b48958 100644
--- a/crunch_global.sql
+++ b/crunch_global.sql
@@ -32,10 +32,7 @@ select
     sum(p_s.gold) as gold,
     sum(p_s.impact_score) as impact_score,
     sum(p_i.surrender) as surrender,
-    _p_i_items_insert,
-    _p_i_item_grants_insert,
-    _p_i_item_uses_insert,
-    _p_i_item_sells_insert
+    _p_i_item_uses_insert
 from participant p
 join participant_stats p_s on (p_s.participant_api_id = p.api_id)
 join participant_items p_i on (p_i.participant_api_id = p.api_id)
@@ -86,7 +83,4 @@ turret_captures = turret_captures + values(turret_captures),
 gold = gold + values(gold),
 impact_score = impact_score + values(impact_score),
 surrender = surrender + values(surrender),
-_p_i_items_update,
-_p_i_item_grants_update,
-_p_i_item_uses_update,
-_p_i_item_sells_update
+_p_i_item_uses_update
-- 
cgit v1.3.1

