From c1f3ee04077420be4ac016d9fc8af9f1ccc8d787 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Tue, 28 Feb 2017 18:01:50 +0100
Subject: support split queries

---
 queries/player.sql | 9 ---------
 1 file changed, 9 deletions(-)
 delete mode 100644 queries/player.sql

(limited to 'queries/player.sql')

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
-- 
cgit v1.3.1

