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=".*"'
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=".*"'