# Puis-je créer un badge pour les 'nouveaux contributeurs'?
**URL:** https://meta.discourse.org/t/can-i-create-a-badge-for-new-contributors/354974
**Category:** Support
**Created:** [Février 28, 2025, 6: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:** 2
**Page:** 1
### Author:  [@copymonopoly](https://meta.discourse.org/u/copymonopoly)
#### Post date: [Février 28, 2025, 6:03 UTC](https://meta.discourse.org/t/can-i-create-a-badge-for-new-contributors/354974/1 "2025-02-28T06:03:53Z")
> [@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?
```sql
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
```
Je veux savoir comment transformer une requête SQL en paramètre d’insigne. Je veux que les utilisateurs reçoivent un badge « Nouveaux contributeurs » lorsqu’ils publient leur premier message.
---
### Author:  [@ondrej](https://meta.discourse.org/u/ondrej)
#### Post date: [Février 28, 2025, 9:07 UTC](https://meta.discourse.org/t/can-i-create-a-badge-for-new-contributors/354974/2 "2025-02-28T21:07:14Z")
Bonjour Copymonopoly,
Avez-vous jeté un œil au sujet ci-dessous ?
> [@Enable Badge SQL](https://meta.discourse.org/t/enable-badge-sql/47894):
>
> bookmark This guide explains how to enable Badge SQL in Discourse and discusses the associated security and performance risks. person_raising_hand Required user level: Administrator warning Enabling Badge SQL can pose security and performance risks. To maintain security and performance integrity, as of Discourse 1.6, the ability for administrators to edit badge SQL directly is disabled by default. The two primary concerns around enabling Badge SQL are: Security: Allowing direct SQL…