# 토픽 읽기 배지가 있나요?

**URL:** https://meta.discourse.org/t/badge-for-reading-a-topic/281534
**Category:** Data & reporting
**Tags:** sql-triggered-badge
**Created:** [10월 8, 2023, 1:23오후 UTC](https://meta.discourse.org/t/badge-for-reading-a-topic/281534 "2023-10-08T13:23:15Z")
**Posts on this page:** 1
**Showing post:** 2

<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: [10월 8, 2023, 8:09오후 UTC](https://meta.discourse.org/t/badge-for-reading-a-topic/281534/2 "2023-10-08T20:09:11Z")

</div>

이것이 다음과 같은 방식으로 가능할 것 같습니다:

```sql
SELECT user_id, CURRENT_TIMESTAMP AS granted_at
FROM topic_users
WHERE topic_id = 281534
  AND total_msecs_viewed/60000 >= 5 -- 최소 시청 시간(분)

```

---

_[View the full topic](https://meta.discourse.org/t/badge-for-reading-a-topic/281534)._