특정 사용자가 수행한 토픽 작업을 반환하는 쿼리?

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.

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

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

I’ve created several queries – some of them quite complex and including parameters – with the help of ChatGPT.

There’s definitely a learning curve, but as your prompting improves and with a basic understanding of SQL, using the Data Explorer actually becomes fun :slight_smile: