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 (5408, 5413, 5414, 5415, 5416, 5435, 5439, 5441, 5444, 5445, 5446, 3186, 3187, 3188, 3189, 3190, 3193, 3227, 3228, 3229, 3230, 3231, 3235, 3236, 3237, 3240, 3242, 3243, 10658, 15998)) 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,5408,5413,5414,5415,5416,5435,5439,5441,5444,5445,5446,3186,3187,3188,3189,3190,3193,3227,3228,3229,3230,3231,3235,3236,3237,3240,3242,3243,10658,15998)
-
SKU: OLY-11337
Model: 261506
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-12200
Model: 260112
Condition: New-In-Box
-
SKU: OLY-12324
Model: 200662
Condition: New-In-Box
-
SKU: OLY-12326
Model: 200661
Condition: New-In-Box
-
SKU: OLY-12340
Model: 260106
Condition: New-In-Box
-
SKU: OLY-21110
Model: 200482
Condition: New-In-Box
-
SKU: OLY-23100
Model: 200667
Condition: New-In-Box
-
SKU: OLY-23130
Model: 202059
Condition: New-In-Box
-
SKU: OLY-60200
Model: 141970
Condition: New-In-Box
-
SKU: OLY-60356
Model: 145045-410
Condition: New-In-Box
-
SKU: OLY-60400
Model: 147026
Condition: New-In-Box
-
SKU: OLY-12122
Model: 260115
Condition: New-In-Box
-
SKU: OLY-12132
Model: 260116
Condition: New-In-Box
-
SKU: OLY-12300
Model: 200663
Condition: New-In-Box
-
SKU: OLY-12320
Model: 200664
Condition: New-In-Box
-
SKU: OLY-12328
Model: 200707
Condition: New-In-Box
-
SKU: OLY-15302
Model: 260057
Condition: New-In-Box
-
SKU: OLY-21120
Model: 202034
Condition: New-In-Box
-
SKU: OLY-21200
Model: 200846
Condition: New-In-Box
-
SKU: OLY-21218
Model: 202288
Condition: New-In-Box
-
SKU: OLY-21222
Model: 202165
Condition: New-In-Box
-
SKU: OLY-21400
Model: 200544
Condition: New-In-Box
-
SKU: OLY-22420
Model: 200897
Condition: New-In-Box
-
SKU: OLY-23124
Model: 200788
Condition: New-In-Box
-
SKU: OLY-23126
Model: 200776
Condition: New-In-Box
-
SKU: OLY-24226
Model: 202057
Condition: New-In-Box
-
SKU: OLY-50130
Model: 118703
Condition: New-In-Box
-
SKU: OLY-60350
Model: 145031
Condition: New-In-Box
-
SKU: OLY-11340
Model: V311030SU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds
-
SKU: OLY-11346N
Model: V311040BU000
Condition: New-In-Box
Mount Type: Micro Four-Thirds