From 34e3a8871cdfaa4675bfd8e96c38dfe9426ab2ec Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Thu, 11 May 2017 17:43:12 +0200
Subject: prevent fame calculation being mixed during two concurrent team
 updates

---
 crunch_team.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'crunch_team.sql')

diff --git a/crunch_team.sql b/crunch_team.sql
index a11cc33..3d55e25 100644
--- a/crunch_team.sql
+++ b/crunch_team.sql
@@ -31,7 +31,7 @@ JOIN (
         JOIN team t ON tm.team_id = t.id
         JOIN roster r ON p.roster_api_id = r.api_id
         JOIN `match` m ON r.match_api_id = m.api_id
-        WHERE t.id IN (:team_ids)
+        WHERE t.id = :team_id
         GROUP BY t.id, m.api_id, r.id
     ) AS cnt_by_m
     JOIN participant p ON p.match_api_id = cnt_by_m.m_api_id
-- 
cgit v1.3.1

