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 in WordPress database
This post brought to you by RocketGeek, ButlerBlog, and the following:
A curated collection of code snippets for WordPress