如何跟踪哪些用户查看了特定主题？

[mcwumbly (Dave McClure)]

看起来你链接的那篇帖子确实有一个示例：

@ditatompel

谁（已登录用户）查看了特定主题

-- [参数]
-- int :topic_id = 1

SELECT
    title,
    viewed_at,
    tv.user_id
FROM topics t
LEFT JOIN topic_views tv
    ON t.id = tv.topic_id
WHERE category_id IS NOT NULL
    AND tv.user_id IS NOT NULL
    AND t.id = :topic_id
ORDER BY viewed_at DESC
LIMIT 1000