Requête pour retourner les actions de sujet effectuées par un utilisateur spécifique ?

Données et rapports
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.

1 « J'aime »
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