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, 19232, 19235, 20866, 44319, 44321, 44404, 527780, 288568, 253389, 253390, 253391, 80373, 80374, 80375, 80376, 84801, 84802, 91047, 91049, 91050, 91051, 91053, 91054, 91055, 91056, 91769, 96214, 196497, 196498)) 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,19232,19235,20866,44319,44321,44404,527780,288568,253389,253390,253391,80373,80374,80375,80376,84801,84802,91047,91049,91050,91051,91053,91054,91055,91056,91769,96214,196497,196498)
-
SKU: BRN-3102607
Model: B-31.026.01-16
Condition: New-In-Box
-
SKU: BRN-3105307
Model: B-31.053.07
Condition: New-In-Box
-
SKU: BRN-3168307
Model: B-31.683.07
Condition: New-In-Box
-
SKU: BRN-3433600
Model: B-34.336.00
Condition: New-In-Box
-
SKU: BRN-3356800
Model: B-33.568.00
Condition: New-In-Box
-
SKU: BRN-3357900
Model: B-33.579.00
Condition: New-In-Box
-
SKU: BRN-4117500
Model: B-41.175.00
Condition: New-In-Box
-
SKU: BRN-3355003
Model: B-33.550.03
Condition: New-In-Box
-
SKU: BRN-3436900
Model: B-34.369.00
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-3319500
Model: B-33.195.00
Condition: New-In-Box
-
SKU: BRN-3616000
Model: B-36.160.00
Condition: New-In-Box
-
SKU: BRN-3616100
Model: B-36.160.00
Condition: New-In-Box
-
SKU: BRN-3616200
Model: B-36.160.00
Condition: New-In-Box
-
SKU: BRN-3310300
Model: B-33.103.00
Condition: New-In-Box
-
SKU: BRN-3311300
Model: B-33.113.00
Condition: New-In-Box
-
SKU: BRN-3312500
Model: B-33.125.00
Condition: New-In-Box
-
SKU: BRN-3362600
Model: B-33.626.00
Condition: New-In-Box
-
SKU: BRN-3363100
Model: B-33.631.00
Condition: New-In-Box
-
SKU: BRN-3364100
Model: B-33.641.00
Condition: New-In-Box
-
SKU: BRN-3312800
Model: B-33.128.00
Condition: New-In-Box
-
SKU: BRN-3320400
Model: B-33.204.00
Condition: New-In-Box
-
SKU: BRN-3324400
Model: B-33.244.00
Condition: New-In-Box
-
SKU: BRN-3350100
Model: B-33.501.00
Condition: New-In-Box
-
SKU: BRN-3211307
Model: B-32.113.07
Condition: New-In-Box
-
SKU: BRN-3521900
Model: B-35.219.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