diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-05-18 19:54:07 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-05-18 19:54:07 +0200 |
| commit | 5050ca981069283568eb468753dca2cf7608bc88 (patch) | |
| tree | 99b27ed4ee7348719abb3bdf2af6901d23eb9852 | |
| parent | 34e3a8871cdfaa4675bfd8e96c38dfe9426ab2ec (diff) | |
| download | cruncher-5050ca981069283568eb468753dca2cf7608bc88.tar.gz cruncher-5050ca981069283568eb468753dca2cf7608bc88.zip | |
calculate fame only for the last 7d
| -rw-r--r-- | crunch_team.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/crunch_team.sql b/crunch_team.sql index 3d55e25..82e3c6e 100644 --- a/crunch_team.sql +++ b/crunch_team.sql @@ -32,6 +32,7 @@ JOIN ( 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 = :team_id + AND p.created_at > DATE_SUB(CURDATE(), INTERVAL 7 DAY) 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 |