The Scribe badge is a custom badge on meta as a little extra kudos for creating a guide in our documentation category. 
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