# Contagem de distintivos na página do usuário?

**URL:** <https://meta.discourse.org/t/count-of-badges-on-user-page/125611>\
**Category:** Feature\
**Created:** [Agosto 12, 2019, 10:11pm UTC](https://meta.discourse.org/t/count-of-badges-on-user-page/125611 "2019-08-12T22:11:12Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![Nicholas\_Tolstoshev](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/nicholas_tolstoshev/32/62714_2.png) [@Nicholas\_Tolstoshev](https://meta.discourse.org/u/Nicholas_Tolstoshev)\
**Post date:** [Agosto 11, 2022, 5:29pm UTC](https://meta.discourse.org/t/count-of-badges-on-user-page/125611/7 "2022-08-11T17:29:28Z")

</div>

Estou procurando uma contagem de todos os tempos, então, graças à sua orientação, extraí esta consulta do user\_stat.rb e a executei no explorador de dados, e ela me deu uma lista de todos os usuários com a contagem de seus emblemas:

```plaintext
SELECT users.id user_id, COUNT(distinct user_badges.badge_id) distinct_badge_count
        FROM users
        LEFT JOIN user_badges ON user_badges.user_id = users.id
                              AND (user_badges.badge_id IN (SELECT id FROM badges WHERE enabled))
        GROUP BY users.id
        ORDER BY distinct_badge_count DESC

```

---

_[View the full topic](https://meta.discourse.org/t/count-of-badges-on-user-page/125611)._