DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL
Delete orphaned post meta
This post brought to you by RocketGeek, ButlerBlog, and the following:
A curated collection of code snippets for WordPress
A curated collection of code snippets for WordPress
This post brought to you by RocketGeek, ButlerBlog, and the following:
DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL