corsonr/gist:dedfa5ca719488291170

Created November 27, 2015 09:25

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

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

Download ZIP

Delete WooCommerce Orphaned Variations

Raw

gistfile1.txt

	DELETE o FROM `wp_posts` o
	LEFT OUTER JOIN `wp_posts` r
	ON o.post_parent = r.ID
	WHERE r.id IS null AND o.post_type = 'product_variation'

modul4richard commented Jan 7, 2016

can you explain why it has..

DELETE o

while this one..
https://gist.github.com/corsonr/cb4541c0c3d8303c6f5e#file-gistfile1-txt
is..

SELECT *

cheers

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