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, 14725, 15527, 5407, 18337, 79470, 23322, 385339, 288484, 223784, 15998, 16001, 17173, 17175, 17177, 17178, 13959, 15029, 11588, 10658, 61044, 61051, 79469, 23323)) 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,14725,15527,5407,18337,79470,23322,385339,288484,223784,15998,16001,17173,17175,17177,17178,13959,15029,11588,10658,61044,61051,79469,23323)
-
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-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-11336
Model: V315030BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11305N
Model: V311020BU001
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-11298
Model: V313020BU000
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-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-11346N
Model: V311040BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11308N
Model: V311050BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11379
Model: BCL-0980
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11335S
Model: V311060SU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11332N
Model: V314070BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11332S
Model: V314070SU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11346
Model: V311040SU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11308T
Model: V311050SU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11305
Model: V311020SU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11340
Model: V311030SU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-20254G
Model: V104180EU000
Condition: New-In-Box
-
SKU: OLY-20254N
Model: V104180BU000
Condition: New-In-Box
-
SKU: OLY-11335T
Model: V311080BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11301
Model: V312030BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds