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 (15999, 16737, 17174, 5407, 5440, 17816, 18337, 18669, 18939, 73176, 14482, 14725, 15527, 79468, 79470, 87314, 87315, 105852, 23322, 44792, 385339, 445582, 345360, 348316, 240022, 266273, 288484, 327697, 223784, 238004)) 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,15999,16737,17174,5407,5440,17816,18337,18669,18939,73176,14482,14725,15527,79468,79470,87314,87315,105852,23322,44792,385339,445582,345360,348316,240022,266273,288484,327697,223784,238004)
-
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-11335N
Model: V311060BU000
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-11600
Model: V3271200W000
Condition: New-In-Box
-
SKU: OLY-11305N
Model: V311020BU001
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11230
Model: V321210BU000
Condition: New-In-Box
-
SKU: OLY-21141
Model: V6200660U000
Condition: New-In-Box
-
SKU: OLY-15128B
Model: V329180BW000
Condition: New-In-Box
-
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-11370
Model: V315040BU000
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-13109
Model: V6200780J000
Condition: New-In-Box
-
SKU: OLY-13417
Model: V328180BW000
Condition: New-In-Box
-
SKU: OLY-13104
Model: V6210380U000
Condition: New-In-Box
-
SKU: OLY-11298
Model: V313020BU000
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-11400
Model: V313030BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11631
Model: 260036
Condition: New-In-Box
-
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: 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-11375
Model: V315070BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11308H1
Model: V316030BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: SPP-OLY-24510
Model: 202223
Condition: New-In-Box
