diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-10-22 15:55:52 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-10-22 15:55:52 +0200 |
| commit | 256ef079b112b288c5b23f7c0b42d099eb9be807 (patch) | |
| tree | 69a41489212dc7ab040f42f78f7cdd6594bd2c5a | |
| parent | e71bf21c47734f02717ab84c8b4ab4921be23cd9 (diff) | |
| download | cruncher-256ef079b112b288c5b23f7c0b42d099eb9be807.tar.gz cruncher-256ef079b112b288c5b23f7c0b42d099eb9be807.zip | |
add item & surrender columns to pp
| -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 |