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 (19207, 253389, 253390, 253391, 288568, 196497, 196498, 197034, 197041, 202497, 209713, 209714, 210763, 210764, 210765, 210766, 210768, 183902, 183904, 183905, 183906, 183907, 183908, 183909, 183910, 183911, 183912, 183914, 183915, 183916)) 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,19207,253389,253390,253391,288568,196497,196498,197034,197041,202497,209713,209714,210763,210764,210765,210766,210768,183902,183904,183905,183906,183907,183908,183909,183910,183911,183912,183914,183915,183916)
-
SKU: BRN-3102607
Model: B-31.026.01-16
Condition: New-In-Box
-
SKU: BRN-3356200
Model: B-33.562.00
Condition: New-In-Box
-
SKU: BRN-3358200
Model: B-33.582.00
Condition: New-In-Box
-
SKU: BRN-3415300
Model: B-34.153.00
Condition: New-In-Box
-
SKU: BRN-3436900
Model: B-34.369.00
Condition: New-In-Box
-
SKU: BRN-3653200
Model: B-36.532.00
Condition: New-In-Box
-
SKU: BRN-3653500
Model: B-36.535.00
Condition: New-In-Box
-
SKU: BRN-3169507
Model: B-31.695.07
Condition: New-In-Box
-
SKU: BRN-3168507
Model: B-31.685.07
Condition: New-In-Box
-
SKU: BRN-6101007
Model: B-61.010.07
Condition: New-In-Box
-
SKU: BRN-3358400
Model: 33.584.00
Condition: New-In-Box
-
SKU: BRN-3361000
Model: 33.610.00
Condition: New-In-Box
-
SKU: BRN-3104707
Model: 31.047.07
Condition: New-In-Box
-
SKU: BRN-3211607
Model: 32.116.07
Condition: New-In-Box
-
SKU: BRN-3312000
Model: 33.120.00
Condition: New-In-Box
-
SKU: BRN-3357100
Model: 33.571.00
Condition: New-In-Box
-
SKU: BRN-3415200
Model: 34.152.00
Condition: New-In-Box
-
SKU: BRN-3310400
Model: B-33.104.00
Condition: New-In-Box
-
SKU: BRN-3344300
Model: B-33.443.00
Condition: New-In-Box
-
SKU: BRN-3347200
Model: B-33.472.00
Condition: New-In-Box
-
SKU: BRN-3347300
Model: B-33.473.00
Condition: New-In-Box
-
SKU: BRN-3347400
Model: B-33.474.00
Condition: New-In-Box
-
SKU: BRN-3348303
Model: B-33.483.03
Condition: New-In-Box
-
SKU: BRN-3348900
Model: B-33.489.00
Condition: New-In-Box
-
SKU: BRN-3348901
Model: B-33.489.01
Condition: New-In-Box
-
SKU: BRN-3348906
Model: B-33.489.06
Condition: New-In-Box
-
SKU: BRN-3348908
Model: B-33.489.08
Condition: New-In-Box
-
SKU: BRN-3355103
Model: B-33.551.03
Condition: New-In-Box
-
SKU: BRN-3355203
Model: B-33.552.03
Condition: New-In-Box
-
SKU: BRN-3356000
Model: B-33.560.00
Condition: New-In-Box