diff options
| -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 ( |