vmartins · September 29, 2021 11:40
diff --git a/featured_products.sql b/featured_products.sql
 SELECT cpe.entity_id, cpe.sku
 FROM catalog_product_entity cpe
 JOIN catalog_product_entity_int cpei ON cpei.entity_id = cpe.entity_id
 JOIN eav_attribute ea ON ea.entity_type_id = 4 AND ea.attribute_id = cpei.attribute_id
 WHERE ea.attribute_code = 'is_featured'
 AND cpei.value = 1
	SELECT cpe.entity_id, cpe.sku
	FROM catalog_product_entity cpe
	JOIN catalog_product_entity_int cpei ON cpei.entity_id = cpe.entity_id
	JOIN eav_attribute ea ON ea.entity_type_id = 4 AND ea.attribute_id = cpei.attribute_id
	WHERE ea.attribute_code = 'is_featured'
	AND cpei.value = 1