Skip to content

Instantly share code, notes, and snippets.

@nikolazic
Last active July 18, 2018 16:34
Show Gist options
  • Save nikolazic/e890f092c7ef474c26bbdd3f190251b7 to your computer and use it in GitHub Desktop.
Save nikolazic/e890f092c7ef474c26bbdd3f190251b7 to your computer and use it in GitHub Desktop.
Products with no Images Magento 2
SELECT a.row_id, a.sku, a.type_id
FROM `catalog_product_entity` AS a
LEFT JOIN `catalog_product_entity_media_gallery_value_to_entity` AS b
ON a.row_id = b.row_id
WHERE b.value_id IS NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment