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 (14482, 14725, 5407, 5440, 385339, 445582, 327697, 345360, 348316, 238004, 238005, 238006, 238007, 240022, 266273, 288484, 223784, 44792, 73176, 17816, 18337, 18338, 18669, 18939, 15999, 16737, 23322, 79468, 79470, 87315)) 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,14482,14725,5407,5440,385339,445582,327697,345360,348316,238004,238005,238006,238007,240022,266273,288484,223784,44792,73176,17816,18337,18338,18669,18939,15999,16737,23322,79468,79470,87315)
-
SKU: OLY-11616
Model: 260083
Condition: New-In-Box
-
SKU: OLY-11344
Model: V312010BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11336
Model: V315030BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-23128
Model: 200372
Condition: New-In-Box
-
SKU: OLY-11400
Model: V313030BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11631
Model: 260036
Condition: New-In-Box
-
SKU: OLY-11375
Model: V315070BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11377
Model: V335300BW000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
[Black, Red]
SKU: OLY-TG-6 BLACK
Model: V104210BU000, V104210RU000
Condition: New-In-Box
-
SKU: SPP-OLY-24510
Model: 202223
Condition: New-In-Box
-
SKU: SPP-OLY-24511
Model: 202544
Condition: New-In-Box
-
SKU: SPP-OLY-24514
Model: 202364
Condition: New-In-Box
-
SKU: SPP-OLY-24515
Model: 202677
Condition: New-In-Box
-
SKU: OLY-11235
Model: V321240BU000
Condition: New-In-Box
-
SKU: OLY-13421B
Model: V332080BW000
Condition: New-In-Box
-
SKU: OLY-113065N
Model: V314090BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11308H1
Model: V316030BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11176
Model: V311070BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-15128B
Model: V329180BW000
Condition: New-In-Box
-
SKU: OLY-11600
Model: V3271200W000
Condition: New-In-Box
-
SKU: OLY-11305N
Model: V311020BU001
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-13130
Model: V620074U000
Condition: New-In-Box
-
SKU: OLY-11230
Model: V321210BU000
Condition: New-In-Box
-
SKU: OLY-21141
Model: V6200660U000
Condition: New-In-Box
-
SKU: OLY-11340N
Model: V311030BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11306
Model: V314060BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11298
Model: V313020BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11308G
Model: V314080BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11335V
Model: V312040BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-13417
Model: V328180BW000
Condition: New-In-Box