Query to return topic actions done by a certain user?

[Moin]

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

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