From 9a99c0218d75d50d4572da3c76ea23f039d1f0c7 Mon Sep 17 00:00:00 2001 From: schneefux Date: Thu, 4 Jan 2018 16:47:01 +0100 Subject: hotfix for builds only considering casual/ranked --- crunch_global.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'crunch_global.sql') 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 ( -- cgit v1.3.1