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); |
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); |