Find WordPress / WooCommerce Posts without featured Image

SELECT DISTINCT(p.ID) FROM `wp_posts` p
LEFT JOIN wp_posts im ON p.ID = im.post_parent AND im.post_type = "attachment" 
WHERE p.post_status ='publish' 
AND p.post_type = "product" 
AND im.ID IS NULL
AND p.post_content NOT REGEXP 'src=".*"'