benytocarlo · August 4, 2015 19:00
diff --git a/imagenes_productos_magento.sql b/imagenes_productos_magento.sql
 SELECT  *
 FROM  `catalog_product_entity` AS a 
 INNER JOIN  `eav_attribute` AS `attribute` ON `attribute`.attribute_code =  'image'
 AND `attribute`.frontend_input =  'media_image'
 LEFT JOIN  `catalog_product_entity_varchar` AS b ON a.entity_id = b.entity_id
 AND b.attribute_id = attribute.attribute_id
 WHERE `type_id` = 'simple' AND (b.value =  ''
 OR b.value IS NOT NULL 
 OR b.value !=  'no_selection')
	SELECT *
	FROM `catalog_product_entity` AS a
	INNER JOIN `eav_attribute` AS `attribute` ON `attribute`.attribute_code = 'image'
	AND `attribute`.frontend_input = 'media_image'
	LEFT JOIN `catalog_product_entity_varchar` AS b ON a.entity_id = b.entity_id
	AND b.attribute_id = attribute.attribute_id
	WHERE `type_id` = 'simple' AND (b.value = ''
	OR b.value IS NOT NULL
	OR b.value != 'no_selection')