| delete from wp_posts | |
| where post_status in ('auto-draft', 'trash') | |
| or post_type = 'revision'; | |
| delete from wp_postmeta | |
| where not exists (select 'x' from wp_posts where wp_posts.ID = wp_postmeta.post_id); |
[WordPress] リビジョンとか自動下書きとかゴミ箱内の投稿を全部消す SQL
公開済み
