修改示例Gamification评分徽章

[satonotdead]

SELECT user_id, current_timestamp AS granted_at 
FROM gamification_scores
WHERE (:backfill OR user_id IN (:user_ids))
GROUP BY 1
HAVING SUM(score) > 9000

该查询是否可以按年、月或三个月进行限制？

[JammyDodger]

我认为你可以添加类似以下内容：

SELECT user_id, CURRENT_TIMESTAMP AS granted_at 
FROM gamification_scores
WHERE date >= CURRENT_DATE - INTERVAL '1 MONTH'
  AND user_id > 0
  AND (:backfill OR user_id IN (:user_ids))
GROUP BY 1
HAVING SUM(score) > 1000