bookchiq/delete_orphaned_postmeta.sql

Created July 10, 2020 17:02

Star (1) 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/bookchiq/9de974b0fa56a7abff45d4be88b3c381.js"></script>
Save bookchiq/9de974b0fa56a7abff45d4be88b3c381 to your computer and use it in GitHub Desktop.

Download ZIP

SQL to delete orphaned postmeta in WordPress

Raw

delete_orphaned_postmeta.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