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 (16001, 16738, 17089, 17090, 17173, 17175, 17177, 17178, 17287, 17471, 13959, 14107, 14140, 14147, 14155, 14161, 14192, 14193, 14239, 14241, 14594, 14595, 14596, 14725, 14726, 14777, 15006, 15029, 15086, 15527)) 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,16001,16738,17089,17090,17173,17175,17177,17178,17287,17471,13959,14107,14140,14147,14155,14161,14192,14193,14239,14241,14594,14595,14596,14725,14726,14777,15006,15029,15086,15527)
-
SKU: OLY-11308N
Model: V311050BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-13414
Model: V328140BU000
Condition: New-In-Box
-
SKU: OLY-18110
Model: V600079BW000
Condition: New-In-Box
-
SKU: OLY-21322
Model: V622011BU000
Condition: New-In-Box
-
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-11411A
Model: V321200BW000
Condition: New-In-Box
-
SKU: OLY-15127
Model: V329160BW000
Condition: New-In-Box
-
SKU: OLY-11346
Model: V311040SU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11626
Model: 260294
Condition: New-In-Box
-
SKU: OLY-14121
Model: 260341
Condition: New-In-Box
-
SKU: OLY-21520
Model: 202463
Condition: New-In-Box
-
SKU: OLY-21140
Model: V620054SU010
Condition: New-In-Box
-
SKU: OLY-22432
Model: V323090BW000
Condition: New-In-Box
-
SKU: OLY-22319
Model: 261551
Condition: New-In-Box
-
SKU: OLY-22323
Model: 261552
Condition: New-In-Box
-
SKU: OLY-60110
Model: 142600
Condition: New-In-Box
-
SKU: OLY-24521
Model: 202240
Condition: New-In-Box
-
SKU: OLY-18414
Model: V6300560U000
Condition: New-In-Box
-
SKU: OLY-15125
Model: V3291200W000
Condition: New-In-Box
-
SKU: OLY-15124
Model: V3291300W000
Condition: New-In-Box
-
SKU: OLY-11344
Model: V312010BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-13108
Model: 260597
Condition: New-In-Box
-
SKU: OLY-60312
Model: V4571310W000
Condition: New-In-Box
-
SKU: OLY-12341
Model: V327110BW000
Condition: New-In-Box
-
SKU: OLY-11308T
Model: V311050SU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11621
Model: V324482BW000
Condition: New-In-Box
-
SKU: OLY-11370
Model: V315040BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds