diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-08-23 21:11:01 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-08-23 21:11:01 +0200 |
| commit | 6c6826ab1811652f3391089c128592658a1cf784 (patch) | |
| tree | 33d6361edc878207511245bc5c0852702c53360a /crunch_global.sql | |
| parent | a3c78c9512b96a211ac445b68d5af8922d3fc37a (diff) | |
| download | cruncher-6c6826ab1811652f3391089c128592658a1cf784.tar.gz cruncher-6c6826ab1811652f3391089c128592658a1cf784.zip | |
use flat item_use columns, drop dynamic col aggregates
Diffstat (limited to 'crunch_global.sql')
| -rw-r--r-- | crunch_global.sql | 10 |
1 files changed, 2 insertions, 8 deletions
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 |