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/participant.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'queries/participant.sql')

diff --git a/queries/participant.sql b/queries/participant.sql
index e9f8264..d1d81ce 100644
--- a/queries/participant.sql
+++ b/queries/participant.sql
@@ -1,7 +1,7 @@
 SELECT
 
 id AS "apiId",
-relationships->'player'->'data'->>'id' AS "player_apiId",
+relationships->'player'->'data'->>'id' AS "playerId",
 
 attributes->>'actor' AS "hero",
 (attributes->'stats'->>'assists')::int AS "assists",
-- 
cgit v1.3.1

