# בנושא אחד, איך אני רואה מי קרא אותו ורואה את המיקום של המשתמשים?

**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:** [22 בפברואר,‏ 2024,‏ 1:50am 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:** 1
**Showing post:** 2

<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: [22 בפברואר,‏ 2024,‏ 2:47am 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>

You can get some of this info using [Data Explorer](https://meta.discourse.org/t/32566?silent=true).

There are a number of queries in the #data-reporting category. But, note that the `topic_views` table only records the first view by a user. Here’s a related query:

> [@See who viewed topic](https://meta.discourse.org/t/see-who-viewed-topic/29277/11):
>
> 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 …

---

_[View the full topic](https://meta.discourse.org/t/for-one-topic-how-do-i-see-who-read-it-and-see-the-location-of-the-users/296272)._