From bd4be8d1e87231b496f91fddbc7230731051d71f Mon Sep 17 00:00:00 2001
From: Kapil Viren Ahuja <k.v.ahuja@gmail.com>
Date: Wed, 1 Mar 2017 20:10:17 +0530
Subject: fixed player id as parameter

---
 queries/player/count_player_matches.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'queries/player/count_player_matches.sql')

diff --git a/queries/player/count_player_matches.sql b/queries/player/count_player_matches.sql
index 2bb549d..ddfbb66 100644
--- a/queries/player/count_player_matches.sql
+++ b/queries/player/count_player_matches.sql
@@ -11,7 +11,7 @@ where
     match."apiId" = roster."match_apiId" and
     roster."apiId" = participant."roster_apiId" and
     participant."player_apiId" = player."apiId" and
-    player."apiId" = '6eab29f6-eed5-11e6-ba5f-068789513eb5')
+    player."apiId" = $1)
 select
     (select distinct(player_api_id) from plr),
     (select count(*) as played from plr), 
-- 
cgit v1.3.1

