列出每个已“解决”的事件

要列出每个单独的“已解决”事件,您可以使用类似以下的查询:

SELECT 
   acting_user_id, 
   target_topic_id AS topic_id, 
   target_post_id, 
   created_at::date
FROM user_actions
WHERE action_type=15
ORDER BY created_at DESC