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

**URL:** https://meta.discourse.org/t/is-it-possible-to-get-a-list-of-topics-in-a-category-read-by-a-specific-user/61641
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [26.Апрель.2017 14:02:45 UTC](https://meta.discourse.org/t/is-it-possible-to-get-a-list-of-topics-in-a-category-read-by-a-specific-user/61641 "2017-04-26T14:02:45Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![vinothkannans](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/vinothkannans/32/86465_2.png) [@vinothkannans](https://meta.discourse.org/u/vinothkannans)
#### Post date: [26.Апрель.2017 17:12:40 UTC](https://meta.discourse.org/t/is-it-possible-to-get-a-list-of-topics-in-a-category-read-by-a-specific-user/61641/4 "2017-04-26T17:12:40Z")

</div>

```sql
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.

---

_[View the full topic](https://meta.discourse.org/t/is-it-possible-to-get-a-list-of-topics-in-a-category-read-by-a-specific-user/61641)._