diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-10-01 11:56:21 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-10-01 11:56:21 +0200 |
| commit | bdb3f7f980c01ed934a68adbe831f2d325781dab (patch) | |
| tree | e6e711ab798560a915ebaffd948141c177f0a3dc | |
| parent | cd72d251a6242a4f8018d1eb725c16ca120c375f (diff) | |
| download | cruncher-bdb3f7f980c01ed934a68adbe831f2d325781dab.tar.gz cruncher-bdb3f7f980c01ed934a68adbe831f2d325781dab.zip | |
use outer join for p_i for backwards compat
| -rw-r--r-- | crunch_global.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/crunch_global.sql b/crunch_global.sql index 2b48958..173b6d9 100644 --- a/crunch_global.sql +++ b/crunch_global.sql @@ -35,7 +35,7 @@ select _p_i_item_uses_insert from participant p join participant_stats p_s on (p_s.participant_api_id = p.api_id) -join participant_items p_i on (p_i.participant_api_id = p.api_id) +left outer join participant_items p_i on (p_i.participant_api_id = p.api_id) join filter f on (f.dimension_on = 'global' 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 = 'global') join hero h on (p.hero_id = h.id or h.name = 'all') |