diff options
| -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 |