我想导出所有帖子进行分析

[riking (Kane York)]

最简单快捷的方法是：

select post_id, user_id, created_at, raw, cooked from badge_posts where deleted_at is null

将 from posts 替换为 from badge_posts。该查询已自动过滤为仅包含公开帖子。