# Custom 'Scribe' badge

**URL:** https://meta.discourse.org/t/custom-scribe-badge/276814
**Category:** Data & reporting
**Tags:** sql-triggered-badge
**Created:** [August 27, 2023, 9:26am UTC](https://meta.discourse.org/t/custom-scribe-badge/276814 "2023-08-27T09:26:42Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [August 27, 2023, 9:26am UTC](https://meta.discourse.org/t/custom-scribe-badge/276814/1 "2023-08-27T09:26:42Z")

</div>

The [Scribe badge](https://meta.discourse.org/badges/127/scribe) is a custom badge on meta as a little extra kudos for creating a guide in our documentation category. 📝

```sql
SELECT p.user_id, MIN(p.created_at) granted_at, MIN(p.id) post_id
FROM badge_posts p
JOIN topics t ON t.id = p.topic_id
WHERE category_id IN (10, 53, 55, 56, 125, 126, 127) AND p.post_number = 1
GROUP BY p.user_id

```

| | |
| --- | --- |
| Run revocation query daily | |
| Query targets posts | |
| Trigger | Update daily |

Bit of history - [New badge added: Scribe](https://meta.discourse.org/t/new-badge-added-scribe/37481)