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 (5407, 385339, 345360, 288484, 327697, 223784, 15999, 16737, 17174, 14725, 15527, 23322, 44792, 79468, 79470, 18337, 11588, 5408, 10658, 370737, 373473, 15998, 16001, 17173, 17175, 17177, 17178, 13959, 15029, 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,5407,385339,345360,288484,327697,223784,15999,16737,17174,14725,15527,23322,44792,79468,79470,18337,11588,5408,10658,370737,373473,15998,16001,17173,17175,17177,17178,13959,15029,23323)
-
SKU: OLY-11336
Model: V315030BU000
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-11377
Model: V335300BW000
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-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: 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-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-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-11305N
Model: V311020BU001
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-11337
Model: 261506
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11340
Model: V311030SU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
[Black, Silver]
SKU: E-M10 Mark IV
Model: V207130BU000, V207130SU000, V207132BU000, V207132SU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-E-PL10
Model: V205100BU000, V205100NU000, V205100WU000, V205101BU010, V205101NU010, V205101WU010
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-11301
Model: V312030BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds