Created
September 29, 2021 11:40
-
-
Save vmartins/256c94876edafaf93963e5a8193bcd48 to your computer and use it in GitHub Desktop.
Get featured products in Magento 2
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment