diff options
Diffstat (limited to 'crunch_global.sql')
| -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 173b6d9..f2713dc 100644 --- a/crunch_global.sql +++ b/crunch_global.sql @@ -46,6 +46,7 @@ join skill_tier st on ((p.skill_tier between st.start and st.end and s.show_in_w join build b 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 ( |