# 我可以为“新贡献者”创建一个徽章吗？

**URL:** <https://meta.discourse.org/t/can-i-create-a-badge-for-new-contributors/354974>\
**Category:** Support\
**Created:** [2025年二月28日 06:03 UTC](https://meta.discourse.org/t/can-i-create-a-badge-for-new-contributors/354974 "2025-02-28T06:03:53Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![copymonopoly](https://avatars.discourse-cdn.com/v4/letter/c/4491bb/32.png) [@copymonopoly](https://meta.discourse.org/u/copymonopoly)\
**Post date:** [2025年二月28日 06:03 UTC](https://meta.discourse.org/t/can-i-create-a-badge-for-new-contributors/354974/1 "2025-02-28T06:03:53Z")

</div>

> [@Can I find out who are 'new contributors'?](https://meta.discourse.org/t/can-i-find-out-who-are-new-contributors/125461):
>
> In a forum in the early stages of growth, it feels handy to know who has recently made their first post. If I happen to see it, it has a little banner box. But if I don’t see that, is there any way to find the post? (The Admin interface tells me that there has been a new contributor.) I’ve looked in all recently updated threads and don’t see the box. Can I search for all users with only 1 post? Or all users with only a few posts?

```plaintext
SELECT username
FROM users u
JOIN user_stats us
ON u.id = us.user_id
WHERE us.first_post_created_at BETWEEN :start_date::date 
AND :end_date::date

```

我想知道如何将SQL查询转换为徽章设置。我希望用户在发布第一篇帖子时获得“新贡献者”徽章。

---

_[View the full topic](https://meta.discourse.org/t/can-i-create-a-badge-for-new-contributors/354974)._