Zifius · March 24, 2016 00:16
diff --git a/get-gallery-images.sql b/get-gallery-images.sql
 SELECT DISTINCT b.value, a.sku, c.position, c.disabled
 FROM `catalog_product_entity` AS a
 LEFT JOIN `catalog_product_entity_media_gallery` AS b ON a.entity_id = b.entity_id
 INNER JOIN `catalog_product_entity_media_gallery_value` AS c ON c.value_id = b.value_id
 ORDER BY a.sku, c.position
	SELECT DISTINCT b.value, a.sku, c.position, c.disabled
	FROM `catalog_product_entity` AS a
	LEFT JOIN `catalog_product_entity_media_gallery` AS b ON a.entity_id = b.entity_id
	INNER JOIN `catalog_product_entity_media_gallery_value` AS c ON c.value_id = b.value_id
	ORDER BY a.sku, c.position