From 9a99c0218d75d50d4572da3c76ea23f039d1f0c7 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
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

