diff options
Diffstat (limited to 'queries/player.sql')
| -rw-r--r-- | queries/player.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/queries/player.sql b/queries/player.sql new file mode 100644 index 0000000..e847de2 --- /dev/null +++ b/queries/player.sql @@ -0,0 +1,9 @@ +-- count the number of matches we have from that player in the database +-- UPDATE player SET "games_in_db"= +SELECT +COUNT(DISTINCT match."apiId") AS "games_in_db" +FROM player +JOIN participant ON player."apiId" = participant."player_apiId" +JOIN roster ON participant."roster_apiId" = roster."apiId" +JOIN match ON roster."match_apiId" = match."apiId" +WHERE player.id=$1 |