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 (8811, 8813, 3423, 3424, 3427, 3434, 3435, 3436, 3437, 3438, 3441, 5567, 5568, 5569, 5576, 5579, 5580, 5581, 5582, 5584, 5585, 5586, 5587, 5588, 5589, 5590, 5591, 5593, 5594, 5595)) 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,8811,8813,3423,3424,3427,3434,3435,3436,3437,3438,3441,5567,5568,5569,5576,5579,5580,5581,5582,5584,5585,5586,5587,5588,5589,5590,5591,5593,5594,5595)
-
SKU: PHG-915867
Model: 915864
Condition: New-In-Box
-
SKU: PHG-915853
Model: 915836
Condition: New-In-Box
-
SKU: PHG-956145
Model: AKC25K
Condition: New-In-Box
-
SKU: PHG-906922
Model: AKC320R
Condition: New-In-Box
-
SKU: PHG-922457
Model: 401952
Condition: New-In-Box
-
SKU: PHG-918626
Model: PL-5R
Condition: New-In-Box
-
SKU: PHG-918713
Model: 918713
Condition: New-In-Box
-
SKU: PHG-918887
Model: 918887
Condition: New-In-Box
-
SKU: PHG-919032
Model: 919032
Condition: New-In-Box
-
SKU: PHG-919061
Model: 919061
Condition: New-In-Box
-
SKU: PHG-919730
Model: 919730
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