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 (373473, 360660, 248320, 248660, 248661, 248665, 268923, 286894, 290949, 312773, 195731, 219402, 219403, 219404, 235138, 61044, 61051, 61524, 70038, 73172, 73174, 73175, 73177, 73178, 73179, 18320, 18492, 18670, 18758, 19368)) 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,373473,360660,248320,248660,248661,248665,268923,286894,290949,312773,195731,219402,219403,219404,235138,61044,61051,61524,70038,73172,73174,73175,73177,73178,73179,18320,18492,18670,18758,19368)
-
SKU: OLY-E-PL10
Model: V205100BU000, V205100NU000, V205100WU000, V205101BU010, V205101NU010, V205101WU010
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-22327
Model: V321250BW000
Condition: New-In-Box
-
SKU: OLY-22234
Model: V321250BW010
Condition: New-In-Box
-
SKU: OLY-21008
Model: V6300680W000
Condition: New-In-Box
-
SKU: OLY-23164
Model: 202187
Condition: New-In-Box
-
SKU: OLY-231703
Model: V6320120U000
Condition: New-In-Box
-
SKU: OLY-11671
Model: V324762BW000
Condition: New-In-Box
-
SKU: OLY-18347
Model: V6200740U010
Condition: New-In-Box
-
SKU: OLY-11640
Model: V324660BW000
Condition: New-In-Box
-
SKU: OLY-15131
Model: V329210BW000
Condition: New-In-Box
-
SKU: OLY-15002
Model: U10000000480
Condition: New-In-Box
-
SKU: OLY-12010
Model: V327140BW000
Condition: New-In-Box
-
SKU: OLY-12011
Model: V327150BW000
Condition: New-In-Box
-
SKU: OLY-12144
Model: V326180BW000
Condition: New-In-Box
-
SKU: OLY-11620K
Model: V324480BW000
Condition: New-In-Box
-
SKU: OLY-20254G
Model: V104180EU000
Condition: New-In-Box
-
SKU: OLY-20254N
Model: V104180BU000
Condition: New-In-Box
-
SKU: OLY-12153
Model: V327130BW000
Condition: New-In-Box
-
SKU: OLY-60065
Model: V415121SU000
Condition: New-In-Box
-
SKU: OLY-14133
Model: V325460BW000
Condition: New-In-Box
-
SKU: OLY-15126
Model: V329150BW000
Condition: New-In-Box
-
SKU: OLY-15128
Model: V329170BW000
Condition: New-In-Box
-
SKU: OLY-15129
Model: V329190BW000
Condition: New-In-Box
-
SKU: OLY-24150
Model: V600083BW000
Condition: New-In-Box
-
SKU: OLY-24152
Model: V600085OW000
Condition: New-In-Box
-
SKU: OLY-24149
Model: 202559
Condition: New-In-Box
-
SKU: OLY-11210
Model: 261005
Condition: New-In-Box
-
SKU: OLY-11670
Model: V324760BW000
Condition: New-In-Box
-
SKU: OLY-22233
Model: V321190BW010
Condition: New-In-Box
-
SKU: OLY-23131
Model: V3310300W000
Condition: New-In-Box