From bd4be8d1e87231b496f91fddbc7230731051d71f Mon Sep 17 00:00:00 2001 From: Kapil Viren Ahuja 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') 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