Is it possible to get a list of topics in a category read by a specific user?

SELECT tu.topic_id, tu.last_read_post_number FROM topics 
LEFT OUTER JOIN topic_users AS tu ON topics.id = tu.topic_id 
WHERE topics.category_id = 4 AND tu.user_id = 1 AND tu.last_visited_at IS NOT NULL

I guess this is what you are looking for.

5 Likes