diff options
| -rw-r--r-- | crunch_player.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/crunch_player.sql b/crunch_player.sql index bfb1574..b3ca8c6 100644 --- a/crunch_player.sql +++ b/crunch_player.sql @@ -16,9 +16,9 @@ select sum(p_s.duration) as time_spent, -- special player_point facts - (p.trueskill_mu - p.trueskill_sigma) as trueskill, - p.trueskill_mu as trueskill_mu, - p.trueskill_sigma as trueskill_sigma, + max(p.trueskill_mu-p.trueskill_sigma) as trueskill, + sum(p.trueskill_mu) as trueskill_mu, + sum(p.trueskill_sigma) as trueskill_sigma, 0 as elo, sum(p_s.kills) as kills, |