diff options
Diffstat (limited to 'crunch_player.sql')
| -rw-r--r-- | crunch_player.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/crunch_player.sql b/crunch_player.sql index df6243b..0324e23 100644 --- a/crunch_player.sql +++ b/crunch_player.sql @@ -28,7 +28,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) |