| File | Name | Developer | Date |
|---|---|---|---|
| 005.zip | 005 | Sega | 1981 |
| 100lions.zip |
Vitor Martins vmartins
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
| <?php | |
| /** | |
| * Composer Install: | |
| * | |
| * composer require google/apiclient:^2.12.1 | |
| * | |
| * https://github.com/googleapis/google-api-php-client | |
| * https://github.com/googleapis/google-api-php-client-services | |
| */ |
| File | Name | Developer | Date |
|---|---|---|---|
| mhgaiden.zip | Mahjong Hourouki Gaiden (Japan) | Home Data | 1987 |
| mhhonban.zip | Mahjong Housoukyoku Honbanchuu (Japan) | Nichibutsu | 1994 |
vmartins
/ featured_products.sql
Created
September 29, 2021 11:40
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 |