Read history for a particular category

数据与报告
1

Is there a way to write this specific query:

  • For topics in category (category id: 34) viewed by user(s) not in group (executive_board)
    • Display user, display topic, display when viewed.
2

真有趣，这自动顶上来了。而且它再次变得足够相关，我很希望有人能给出答案。

1 个赞
3

是的，看来你为此等了很久。 :slight_smile:
我想也许像这样可以做到？（你需要找到你的 executive_board 的 group_id，并将其替换为 group_id = 3）

SELECT tu.user_id,
       tu.topic_id, 
       tu.last_read_post_number,
       tu.last_visited_at AS read
FROM topics t
LEFT OUTER JOIN topic_users tu ON t.id = tu.topic_id 
WHERE tu.user_id NOT IN (SELECT user_id 
    FROM group_users
    WHERE group_id = 3)
AND t.category_id = 34
AND tu.last_visited_at IS NOT NULL
ORDER BY tu.last_visited_at DESC
1 个赞
4

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