Skip to content

Instantly share code, notes, and snippets.

@alex-79

alex-79/find-products-without-images.sql

Created July 2, 2019 09:40
Show Gist options
  • Save alex-79/8627ae15f9f2f45755001ce31cf701ce to your computer and use it in GitHub Desktop.
Save alex-79/8627ae15f9f2f45755001ce31cf701ce to your computer and use it in GitHub Desktop.
Download ZIP
Magento 2: пошук групованих товарів без зображень
Raw
find-products-without-images.sql
SELECT * FROM `catalog_product_entity` AS a
LEFT JOIN `catalog_product_entity_media_gallery_value` AS b ON a.entity_id = b.entity_id
LEFT JOIN `catalog_product_entity_media_gallery` AS c ON b.value_id = c.value_id WHERE c.value IS NULL AND a.type_id = 'grouped'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment