diff options
| author | vainsocial <vainsocial@prod> | 2018-01-13 11:04:13 +0000 |
|---|---|---|
| committer | vainsocial <vainsocial@prod> | 2018-01-13 11:04:13 +0000 |
| commit | 39604afb4287f3e9cbfb69c0975d760b32488f6b (patch) | |
| tree | 7d3739edadde267f416c55f6d395fd4dda1d6954 /crunch_hero_vs_hero.sql | |
| parent | 4963e137a792727554e175f7de668124e2d741d3 (diff) | |
| download | cruncher-39604afb4287f3e9cbfb69c0975d760b32488f6b.tar.gz cruncher-39604afb4287f3e9cbfb69c0975d760b32488f6b.zip | |
fix surrender being summed with null
Diffstat (limited to 'crunch_hero_vs_hero.sql')
| -rw-r--r-- | crunch_hero_vs_hero.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/crunch_hero_vs_hero.sql b/crunch_hero_vs_hero.sql index 4b31b3f..4e4f124 100644 --- a/crunch_hero_vs_hero.sql +++ b/crunch_hero_vs_hero.sql @@ -33,7 +33,7 @@ select sum(p_s.turret_captures) as turret_captures, sum(p_s.gold) as gold, sum(p_s.impact_score) as impact_score, - sum(p_i.surrender) as surrender, + sum(coalesce(p_i.surrender, 0)) as surrender, _p_i_item_uses_insert from participant p join participant_stats p_s on (p_s.participant_api_id = p.api_id) |