diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-05-11 17:43:12 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-05-11 17:43:12 +0200 |
| commit | 34e3a8871cdfaa4675bfd8e96c38dfe9426ab2ec (patch) | |
| tree | 59d4e196242d910560915d2d08d87520536c32d1 /crunch_team.sql | |
| parent | 764572460cc6b50fd253d45bf0821e00e7192f66 (diff) | |
| download | cruncher-release/2.3.0.tar.gz cruncher-release/2.3.0.zip | |
prevent fame calculation being mixed during two concurrent team updatesrelease/2.3.1release/2.3.0
Diffstat (limited to 'crunch_team.sql')
| -rw-r--r-- | crunch_team.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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 |