diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-07-24 13:26:59 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-07-24 13:26:59 +0200 |
| commit | 0b37ae96e446df3af3f37694672daaca2fbc2c96 (patch) | |
| tree | 5ecf0ae25913725274bc4732fd8e0bc271010b55 /crunch_player.sql | |
| parent | 6e2b1743d110056f2b11d2c2a9515072be00a96e (diff) | |
| download | cruncher-0b37ae96e446df3af3f37694672daaca2fbc2c96.tar.gz cruncher-0b37ae96e446df3af3f37694672daaca2fbc2c96.zip | |
split crunch queues
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 8ddedb4..75432e8 100644 --- a/crunch_player.sql +++ b/crunch_player.sql @@ -40,7 +40,7 @@ join filter f on (f.dimension_on = 'player' and (f.name = 'all' or f.id in (sele join series s on (p_s.created_at between s.start and s.end and s.dimension_on = 'player') join hero h on (p.hero_id = h.id or h.name = 'all') join role r on ((p.role_id = r.id and h.name = 'all') or r.name = 'all') -- do not cross hero x role -join game_mode gm on (p.game_mode_id = gm.id or gm.name = 'all') +join game_mode gm on ((p.game_mode_id = gm.id and h.name = 'all' and r.name = 'all') or gm.name = 'all') -- do not cross mode x role / mode x hero where p.api_id in (:participant_api_ids) |