# Reading Confirmations

**URL:** https://meta.discourse.org/t/reading-confirmations/335377
**Category:** Feature
**Created:** [November 9, 2024, 8:27pm UTC](https://meta.discourse.org/t/reading-confirmations/335377 "2024-11-09T20:27:51Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![Lilly](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/lilly/32/575047_2.png) [@Lilly](https://meta.discourse.org/u/Lilly)
#### Post date: [November 9, 2024, 8:47pm UTC](https://meta.discourse.org/t/reading-confirmations/335377/3 "2024-11-09T20:47:29Z")

</div>

Hi @janns6023 👋 welcome 🙂

I’m not sure what format or how much data you are looking for, but you can probably use [data explorer](https://meta.discourse.org/t/32566?silent=true) for something like this.

> [@Is it possible to see the topics a user has viewed?](https://meta.discourse.org/t/is-it-possible-to-see-the-topics-a-user-has-viewed/155413/2):
>
> Maybe something like: Who (logged in user) view specific topic -- [params] -- 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 Last 100 topic view by user -- [params] -- int :user\_id = 1 SELECT tv.user\_id, title, viewed\_at, views, t.user\_id FROM topics t LEFT JOIN topic\_vi…

---

_[View the full topic](https://meta.discourse.org/t/reading-confirmations/335377)._