啊，那真不幸。如果你能访问数据浏览器插件，我认为类似下面的内容应该可以复制特定用户的 /deleted/posts 列表（为了方便起见，还加入了 post_id）：
-- [params]
-- user_id :user_id
SELECT p.created_at AS reltime$time,
id AS post_id,
id
FROM posts p
WHERE p.user_id = :user_id
AND p.deleted_at IS NOT NULL
ORDER BY p.created_at DESC