From 9ae212a23754035be50e9125a7966544e2d525fb Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Mon, 20 Feb 2017 17:33:26 +0100
Subject: update queries to work with vainsocial.com#develop

---
 queries/match.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'queries/match.sql')

diff --git a/queries/match.sql b/queries/match.sql
index 2963172..5dfa692 100644
--- a/queries/match.sql
+++ b/queries/match.sql
@@ -7,9 +7,9 @@ attributes->>'gameMode' AS "gameMode",
 COALESCE(NULLIF(attributes->>'patchVersion', ''), '0') AS "patchVersion",
 attributes->>'shardId' AS "shardId",
 attributes->'stats'->>'endGameReason' AS "endGameReason",
-attributes->'stats'->>'queue' AS "queue",
+attributes->'stats'->>'queue' AS "queue" --,
 
-relationships->'rosters'->'data'->0->>'id' as roster_1,
-relationships->'rosters'->'data'->1->>'id' as roster_2
+--relationships->'rosters'->'data'->0->>'id' as "roster_1",
+--relationships->'rosters'->'data'->1->>'id' as "roster_2"
 
 FROM "match"
-- 
cgit v1.3.1

