anton-roos/select-products-no-featured-image.sql

Created May 25, 2020 14:53

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/anton-roos/bde518dc7a8307ab4863ac132a421fd9.js"></script>
Save anton-roos/bde518dc7a8307ab4863ac132a421fd9 to your computer and use it in GitHub Desktop.

Download ZIP

Select WordPress Posts or WooCommerce Products with no featured image.

Raw

select-products-no-featured-image.sql

	SELECT ID
	FROM `wp_posts`
	WHERE ID
	NOT IN (select `post_id` from `wp_postmeta` WHERE `meta_key`="_thumbnail_id")
	AND `post_type`="product"

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