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 (6239, 6241, 6242, 6243, 6244, 6245, 6246, 6247, 6248, 6249, 6250, 6251, 6252, 6253, 6254, 6255, 4334, 4335, 4336, 4337, 4338, 4339, 4340, 4341, 4342, 4343, 4344, 4345, 4346, 4347)) 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,6239,6241,6242,6243,6244,6245,6246,6247,6248,6249,6250,6251,6252,6253,6254,6255,4334,4335,4336,4337,4338,4339,4340,4341,4342,4343,4344,4345,4346,4347)
-
SKU: SPE-850315
Model: 12231-7
Condition: New-In-Box
-
SKU: SPE-852820
Model: 13550
Condition: New-In-Box
-
SKU: SPE-850940
Model: 13555
Condition: New-In-Box
-
SKU: SPE-850930
Model: 14205
Condition: New-In-Box
-
SKU: SPE-851210
Model: 14222
Condition: New-In-Box
-
SKU: SPE-851205
Model: 14220
Condition: New-In-Box
-
SKU: SPE-851225
Model: 14231
Condition: New-In-Box
-
SKU: SPE-851230
Model: 14235
Condition: New-In-Box
-
SKU: SPE-851450
Model: 14240
Condition: New-In-Box
-
SKU: SPE-851455
Model: 14250
Condition: New-In-Box
-
SKU: SPE-851120
Model: 14560
Condition: New-In-Box
-
SKU: SPE-851160
Model: 14576
Condition: New-In-Box
-
SKU: SPE-850950
Model: 15552
Condition: New-In-Box
-
SKU: SPE-851175
Model: 24577
Condition: New-In-Box
-
SKU: SPE-852975
Model: 25527
Condition: New-In-Box
-
SKU: SPE-852980
Model: 25528
Condition: New-In-Box
-
SKU: SPE-850910
Model: 13200
Condition: New-In-Box
-
SKU: SPE-852825
Model: 13551
Condition: New-In-Box
-
SKU: SPE-853095
Model: 14209
Condition: New-In-Box
-
SKU: SPE-851200
Model: 14219
Condition: New-In-Box
-
SKU: SPE-851215
Model: 14225
Condition: New-In-Box
-
SKU: SPE-851227
Model: 14238
Condition: New-In-Box
-
SKU: SPE-851460
Model: 14254
Condition: New-In-Box
-
SKU: SPE-851125
Model: 14561
Condition: New-In-Box
-
SKU: SPE-851145
Model: 14570
Condition: New-In-Box
-
SKU: SPE-851150
Model: 14571
Condition: New-In-Box
-
SKU: SPE-851155
Model: 14575
Condition: New-In-Box
-
SKU: SPE-853075
Model: 14619
Condition: New-In-Box
-
SKU: SPE-851180
Model: 24580
Condition: New-In-Box
-
SKU: SPE-852985
Model: 25529
Condition: New-In-Box