Query to return topic actions done by a certain user?

Data & reporting
1

Hi,

A user unnecessarily renamed and recategorized some topics. I noticed some, but I think there are others. I’d like to have the list using a data explorer query.

ask.discourse.org was of no help for this request, so perhaps some knowledgeable users here will have more to share :slight_smile:
I’m not even sure which table(s) to look at to start.

2 Likes
2

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

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