diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-10-10 20:37:51 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-10-10 20:37:51 +0200 |
| commit | 3ebe9932642bf96b888946d555420c4b4579afda (patch) | |
| tree | 925525ad5390a8ffd6c373634baf270515c6b104 | |
| parent | 749869b2abbb77ebaab82f12cec7c01a69ac1d02 (diff) | |
| download | cruncher-3ebe9932642bf96b888946d555420c4b4579afda.tar.gz cruncher-3ebe9932642bf96b888946d555420c4b4579afda.zip | |
move trueskill_ranked to participant_items
| -rw-r--r-- | crunch_player.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/crunch_player.sql b/crunch_player.sql index 4ad2dd4..41809f1 100644 --- a/crunch_player.sql +++ b/crunch_player.sql @@ -17,7 +17,7 @@ select -- special player_point facts max(p.trueskill_mu-p.trueskill_sigma) as trueskill_max, - max(p.trueskill_ranked_mu-p.trueskill_ranked_sigma) as trueskill_ranked_max, + max(p_i.trueskill_ranked_mu-p_i.trueskill_ranked_sigma) as trueskill_ranked_max, sum(p.trueskill_delta) as trueskill_delta, sum(p.trueskill_mu) as trueskill_mu, sum(p.trueskill_sigma) as trueskill_sigma, @@ -38,6 +38,7 @@ select sum(p_s.impact_score) as impact_score 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) -- left outer join users u on p.player_api_id = u.player_api_id -- u.access_type is null -> unregistered join filter f on (f.dimension_on = 'player' and (f.name = 'all' or f.id in (select gpf.filter_id from global_point_filters gpf where gpf.match_api_id = p.match_api_id))) join series s on (p_s.created_at between s.start and s.end and s.dimension_on = 'player') |