如何查看一个帖子的阅读者和用户位置？

[kenjdarhan (Ken)]

我想通过查看用户阅读了哪些主题以及用户来自世界何处来统计主题的有用性。

这可能吗？

感谢任何帮助。

[Lilly]

您可以使用数据探索器获取部分信息。

Data & reporting 类别中有许多查询。但请注意，topic_views 表仅记录用户首次查看的次数。这是一个相关的查询：

See who viewed topic

I’ve got a Data Explorer 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 …