diff options
Diffstat (limited to 'queries')
| -rw-r--r-- | queries/player.sql | 9 |
1 files changed, 0 insertions, 9 deletions
diff --git a/queries/player.sql b/queries/player.sql deleted file mode 100644 index e847de2..0000000 --- a/queries/player.sql +++ /dev/null @@ -1,9 +0,0 @@ --- 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 |