Skip to content

Instantly share code, notes, and snippets.

@mjoraid
mjoraid / unassign_product_images_based_on_category.sql
Last active August 5, 2018 07:14
Unassign Product Images Based on Category ID
DELETE
EntityMediaGallery
FROM
`catalog_product_entity_media_gallery_value_to_entity` ValueToEntity
INNER JOIN `catalog_product_entity_media_gallery_value` MediaGalleryValue
ON ValueToEntity.entity_id = MediaGalleryValue.entity_id
AND ValueToEntity.`value_id` = MediaGalleryValue.`value_id`
/* and MediaGalleryValue.`entity_id` = 320*/
INNER JOIN `catalog_product_entity_media_gallery` EntityMediaGallery
ON ValueToEntity.`value_id` = EntityMediaGallery.`value_id`