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 (5160, 5166, 5167, 5173, 5174, 5175, 5194, 5195, 5198, 5199, 5200, 5201, 5203, 2819, 2820, 2822, 2824, 2825, 2826, 2829, 2831, 2834, 2835, 2836, 2838, 2843, 84772)) 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,5160,5166,5167,5173,5174,5175,5194,5195,5198,5199,5200,5201,5203,2819,2820,2822,2824,2825,2826,2829,2831,2834,2835,2836,2838,2843,84772)
-
SKU: MET-00001M
Model: MZ15673
Condition: New-In-Box
-
SKU: MET-00048
Model: MZ53129
Condition: New-In-Box
-
SKU: MET-00054
Model: MZ5308
Condition: New-In-Box
-
SKU: MET-00108
Model: MZ 54557
Condition: New-In-Box
-
SKU: MET-00118
Model: MZ 5484
Condition: New-In-Box
-
SKU: MET-00120
Model: MZ 5512
Condition: New-In-Box
-
SKU: MET-00122
Model: MZ 5513
Condition: New-In-Box
-
SKU: MET-00128
Model: MZ 5521
Condition: New-In-Box
-
SKU: MET-00138
Model: MZ 5532
Condition: New-In-Box
-
SKU: MET-00140
Model: MZ 5534
Condition: New-In-Box
-
SKU: MET-00146
Model: MZ 5548
Condition: New-In-Box
-
SKU: MET-00148
Model: MZ 5549
Condition: New-In-Box
-
SKU: MET-00186
Model: MZ 76252
Condition: New-In-Box
-
SKU: MET-00001J
Model: MZ15622
Condition: New-In-Box
-
SKU: MET-00012
Model: MZ 50129
Condition: New-In-Box
-
SKU: MET-00030
Model: MZ 52822D
Condition: New-In-Box
-
SKU: MET-00038
Model: MZ 53045
Condition: New-In-Box
-
SKU: MET-00044
Model: MZ 53102
Condition: New-In-Box
-
SKU: MET-00046
Model: MZ 5312
Condition: New-In-Box
-
SKU: MET-00064
Model: MZ 53402
Condition: New-In-Box
-
SKU: MET-00076
Model: MZ 5376
Condition: New-In-Box
-
SKU: MET-00126
Model: MZ 5520
Condition: New-In-Box
-
SKU: MET-00142
Model: MZ 55450
Condition: New-In-Box
-
SKU: MET-00144
Model: MZ 5546
Condition: New-In-Box
-
SKU: MET-00172
Model: MZ57656
Condition: New-In-Box
-
SKU: MET-00182
Model: MZ5850
Condition: New-In-Box
-
SKU: MET-00027
Model: MZ52311C
Condition: New-In-Box