tomfordweb/wp-post_meta-orphans.sql

Created December 2, 2017 18:09

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/tomfordweb/04d5dd1b1a4d06f62bde6f9a2a6eb5c8.js"></script>
Save tomfordweb/04d5dd1b1a4d06f62bde6f9a2a6eb5c8 to your computer and use it in GitHub Desktop.

Download ZIP

WordPress orphaned post meta

Raw

wp-post_meta-orphans.sql

	DELETE pm
	FROM wp_postmeta pm
	LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
	WHERE wp.ID IS NULL

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment