# Problema ao desativar a repetição de distintivos

**URL:** <https://meta.discourse.org/t/issue-with-disabling-badge-repetition/370948>\
**Category:** Product Support\
**Tags:** badges, sql-triggered-badge\
**Created:** [Junho 19, 2025, 8:49pm UTC](https://meta.discourse.org/t/issue-with-disabling-badge-repetition/370948 "2025-06-19T20:49:28Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![satonotdead](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/satonotdead/32/447830_2.png) [@satonotdead](https://meta.discourse.org/u/satonotdead)\
**Post date:** [Junho 20, 2025, 5:22am UTC](https://meta.discourse.org/t/issue-with-disabling-badge-repetition/370948/5 "2025-06-20T05:22:15Z")

</div>

```plaintext
SELECT 
    gs.user_id, 
    current_timestamp AS granted_at 
FROM 
    gamification_scores gs
WHERE 
    (:backfill OR gs.user_id IN (:user_ids))
    AND gs.date >= (current_date - interval '1 month')
    AND NOT EXISTS (
        SELECT 1 
        FROM user_badges ub
        WHERE ub.user_id = gs.user_id
        AND ub.badge_id = YOURIDOFBADGE
    )
GROUP BY 
    gs.user_id
HAVING 
    SUM(gs.score) > 11

```

---

_[View the full topic](https://meta.discourse.org/t/issue-with-disabling-badge-repetition/370948)._