diff options
| author | Kapil Viren Ahuja <k.v.ahuja@gmail.com> | 2017-03-01 20:10:17 +0530 |
|---|---|---|
| committer | Kapil Viren Ahuja <k.v.ahuja@gmail.com> | 2017-03-01 20:10:17 +0530 |
| commit | bd4be8d1e87231b496f91fddbc7230731051d71f (patch) | |
| tree | 8a98f2b775fb3413ea2467eef20d105a7c513cd5 | |
| parent | 90d5f8edb1d5a6cb95a18c48eca98e93cf4d34b7 (diff) | |
| download | compiler-bd4be8d1e87231b496f91fddbc7230731051d71f.tar.gz compiler-bd4be8d1e87231b496f91fddbc7230731051d71f.zip | |
fixed player id as parameter
| -rw-r--r-- | queries/player/count_player_matches.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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), |