# Query to return topic actions done by a certain user?

**URL:** https://meta.discourse.org/t/query-to-return-topic-actions-done-by-a-certain-user/385057
**Category:** Data & reporting
**Created:** [October 8, 2025, 5:51pm UTC](https://meta.discourse.org/t/query-to-return-topic-actions-done-by-a-certain-user/385057 "2025-10-08T17:51:08Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![Moin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/moin/32/554653_2.png) [@Moin](https://meta.discourse.org/u/Moin)
#### Post date: [October 8, 2025, 6:26pm UTC](https://meta.discourse.org/t/query-to-return-topic-actions-done-by-a-certain-user/385057/2 "2025-10-08T18:26:27Z")

</div>

I think the post revisions table could be a good start.

```sql
SELECT *
from post_revisions
where user_id = 1
order by updated_at desc

```

---

_[View the full topic](https://meta.discourse.org/t/query-to-return-topic-actions-done-by-a-certain-user/385057)._