SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_1` ON mst_sorting_index_1.product_id = e.entity_id AND mst_sorting_index_1.store_id = 1
LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_0` ON mst_sorting_index_0.product_id = e.entity_id AND mst_sorting_index_0.store_id = 0
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id
LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (14141, 14142, 14143, 14144, 14145, 14146, 15037, 8811, 8813, 5567, 5568, 5569, 5576, 5579, 5580, 5581, 5582, 5584, 5585, 5586, 5587, 5588, 5589, 5590, 5591, 5593, 5594, 5595, 5596, 3423)) ORDER BY IFNULL(mst_sorting_index_1.factor_2_score, IFNULL(mst_sorting_index_0.factor_2_score, 0)) * 50 desc, FIELD(e.entity_id,14141,14142,14143,14144,14145,14146,15037,8811,8813,5567,5568,5569,5576,5579,5580,5581,5582,5584,5585,5586,5587,5588,5589,5590,5591,5593,5594,5595,5596,3423)
-
SKU: PHG-956123
Model: 956123
Condition: New-In-Box
-
SKU: PHG-956135
Model: 956135
Condition: New-In-Box
-
SKU: PHG-905808
Model: 905808
Condition: New-In-Box
-
SKU: PHG-905634
Model: 905634
Condition: New-In-Box
-
SKU: PHG-905779
Model: 905779
Condition: New-In-Box
-
SKU: PHG-956073
Model: 956073
Condition: New-In-Box
-
SKU: PHG-900140
Model: 900140
Condition: New-In-Box
-
SKU: PHG-915867
Model: 915864
Condition: New-In-Box
-
SKU: PHG-915853
Model: 915836
Condition: New-In-Box
-
SKU: PHG-932284
Model: 932284
Condition: New-In-Box
-
SKU: PHG-906910
Model: AK320
Condition: New-In-Box
-
SKU: PHG-906939
Model: AK320B
Condition: New-In-Box
-
SKU: PHG-911898
Model: 911898
Condition: New-In-Box
-
SKU: PHG-915755
Model: PL1250C
Condition: New-In-Box
-
SKU: PHG-915871
Model: 915871
Condition: New-In-Box
-
SKU: PHG-917437
Model: 917437
Condition: New-In-Box
-
SKU: PHG-917930
Model: 917930
Condition: New-In-Box
-
SKU: PHG-918742
Model: 918742
Condition: New-In-Box
-
SKU: PHG-918771
Model: 918771
Condition: New-In-Box
-
SKU: PHG-918800
Model: 918800
Condition: New-In-Box
-
SKU: PHG-918916
Model: 918916
Condition: New-In-Box
-
SKU: PHG-919090
Model: 919090
Condition: New-In-Box
-
SKU: PHG-916741
Model: 916741
Condition: New-In-Box
-
SKU: PHG-917311
Model: 917311
Condition: New-In-Box
-
SKU: PHG-919235
Model: 919235
Condition: New-In-Box
-
SKU: PHG-959346
Model: 959346
Condition: New-In-Box
-
SKU: PHG-921932
Model: 921932
Condition: New-In-Box
-
SKU: PHG-922019
Model: 922019
Condition: New-In-Box
-
SKU: PHG-922048
Model: 922048
Condition: New-In-Box
-
SKU: PHG-956145
Model: AKC25K
Condition: New-In-Box