# 특정 주제에서 누가 읽었는지와 사용자 위치를 확인하는 방법은?

**URL:** https://meta.discourse.org/t/for-one-topic-how-do-i-see-who-read-it-and-see-the-location-of-the-users/296272
**Category:** Support
**Created:** [2월 22, 2024, 1:50오전 UTC](https://meta.discourse.org/t/for-one-topic-how-do-i-see-who-read-it-and-see-the-location-of-the-users/296272 "2024-02-22T01:50:25Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![kenjdarhan](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/kenjdarhan/32/298019_2.png) [@kenjdarhan](https://meta.discourse.org/u/kenjdarhan)
#### Post date: [2월 22, 2024, 1:50오전 UTC](https://meta.discourse.org/t/for-one-topic-how-do-i-see-who-read-it-and-see-the-location-of-the-users/296272/1 "2024-02-22T01:50:25Z")

</div>

각 주제를 어떤 사용자가 읽었는지, 그리고 해당 사용자가 세계의 어디에 위치해 있는지 확인하여 주제의 유용성에 대한 통계를 만들고 싶습니다.

이것이 가능한가요?

도와주셔서 감사합니다.

---

<div class="post-metadata">

### Author: ![Lilly](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/lilly/32/575047_2.png) [@Lilly](https://meta.discourse.org/u/Lilly)
#### Post date: [2월 22, 2024, 2:47오전 UTC](https://meta.discourse.org/t/for-one-topic-how-do-i-see-who-read-it-and-see-the-location-of-the-users/296272/2 "2024-02-22T02:47:46Z")

</div>

[Data Explorer](https://meta.discourse.org/t/32566?silent=true)를 사용하여 이 정보의 일부를 가져올 수 있습니다.

#data-reporting 카테고리에는 여러 쿼리가 있습니다. 하지만, `topic_views` 테이블은 사용자가 처음 본 것만 기록한다는 점에 유의하세요. 다음은 관련 쿼리입니다:

> [@See who viewed topic](https://meta.discourse.org/t/see-who-viewed-topic/29277/11?u=lilly):
>
> I’ve got a [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query for this (which shows username to enable csv / groups / pms stuff): -- Who viewed this topic? https://meta.discourse.org/t/see-who-viewed-topic/29277/11 -- [params] -- int :topic\_id SELECT tu.user\_id, u.username, total\_msecs\_viewed/1000 AS seconds\_viewed FROM topic\_users tu JOIN users u ON tu.user\_id = u.id WHERE tu.topic\_id = :topic\_id AND total\_msecs\_viewed \> 0 GROUP BY tu.user\_id, u.username, tu.total\_msecs\_viewed ORDER BY tu.total\_msecs\_viewed desc If …

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [4월 7, 2024, 2:15오전 UTC](https://meta.discourse.org/t/for-one-topic-how-do-i-see-who-read-it-and-see-the-location-of-the-users/296272/3 "2024-04-07T02:15:13Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.