diff options
Diffstat (limited to 'crunch_player.sql')
| -rw-r--r-- | crunch_player.sql | 8 |
1 files changed, 6 insertions, 2 deletions
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 |