diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2018-01-04 16:47:01 +0100 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2018-01-04 16:48:44 +0100 |
| commit | 9a99c0218d75d50d4572da3c76ea23f039d1f0c7 (patch) | |
| tree | 7dac3751ce5f6219ac600694e15d1569989283d6 | |
| parent | 0405231040c4f7655bd6b4346f9f5e36b18e5a7e (diff) | |
| download | cruncher-9a99c0218d75d50d4572da3c76ea23f039d1f0c7.tar.gz cruncher-9a99c0218d75d50d4572da3c76ea23f039d1f0c7.zip | |
hotfix for builds only considering casual/ranked
| -rw-r--r-- | crunch_global.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/crunch_global.sql b/crunch_global.sql index 8a051a9..b9ba013 100644 --- a/crunch_global.sql +++ b/crunch_global.sql @@ -46,6 +46,7 @@ join skill_tier st use index() on ((p.skill_tier between st.start and st.end and join build b use index() on (( -- only per patch global s.show_in_web = true and gm.name = 'all' and + p.game_mode_id in (select id from game_mode where name in ('casual', 'ranked')) and -- only casual / ranked reg.name = 'all' and ( |