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 (422575, 246163, 246164, 78833, 78834, 78835, 78836, 78837, 78838, 78843, 78844, 78845, 78846, 78847, 78848, 78849, 78850, 78851, 78852, 78853, 78854, 78855, 78856, 78857, 78858, 78860, 78861, 78862, 78863, 78864)) 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,422575,246163,246164,78833,78834,78835,78836,78837,78838,78843,78844,78845,78846,78847,78848,78849,78850,78851,78852,78853,78854,78855,78856,78857,78858,78860,78861,78862,78863,78864)
-
SKU: LEG-00221
Model: R08-ERB300111725
Condition: New-In-Box
-
SKU: LEG-00223
Model: R08-ERB3008511B
Condition: New-In-Box
-
SKU: LEG-00226
Model: R08-ERB300172225
Condition: New-In-Box
-
SKU: LEG-00200
Model: L21-MOABSAMUS
Condition: New-In-Box
-
SKU: LEG-00210
Model: R-08-ERB1905725
Condition: New-In-Box
-
SKU: LEG-00212
Model: R08-ERB190851125
Condition: New-In-Box
-
SKU: LEG-00214
Model: R08-ERB190111725
Condition: New-In-Box
-
SKU: LEG-00220
Model: R08-ERB3005725
Condition: New-In-Box
-
SKU: LEG-00222
Model: R08-ERB300851125
Condition: New-In-Box
-
SKU: LEG-00224
Model: R08-ERB300131925
Condition: New-In-Box
-
SKU: LEG-00230
Model: R08-ERN1905725
Condition: New-In-Box
-
SKU: LEG-00232
Model: R08-ERN190851125
Condition: New-In-Box
-
SKU: LEG-00234
Model: R08-ERN190111725
Condition: New-In-Box
-
SKU: LEG-00240
Model: R08-ERN3005725
Condition: New-In-Box
-
SKU: LEG-00242
Model: R08-ERN300851125
Condition: New-In-Box
-
SKU: LEG-00244
Model: R08-ERN300131925
Condition: New-In-Box
-
SKU: LEG-00250
Model: F01-JBR3055725
Condition: New-In-Box
-
SKU: LEG-00252
Model: F01-JBR305851125
Condition: New-In-Box
-
SKU: LEG-00254
Model: F01-JBR305131925
Condition: New-In-Box
-
SKU: LEG-00260
Model: F01-LSD330851125
Condition: New-In-Box
-
SKU: LEG-00262
Model: F01-LSD330111425
Condition: New-In-Box
-
SKU: LEG-00270
Model: F01-LEL3005750
Condition: New-In-Box
-
SKU: LEG-00272
Model: F01-LEL300851150
Condition: New-In-Box
-
SKU: LEG-00274
Model: F01-LEL300131950
Condition: New-In-Box
-
SKU: LEG-00280
Model: F01-SLP260851125
Condition: New-In-Box
-
SKU: LEG-00282
Model: F01-SLP260111425
Condition: New-In-Box
-
SKU: LEG-00284
Model: F01-SLP260131925
Condition: New-In-Box
-
SKU: LEG-00290
Model: F01-SLS300851125
Condition: New-In-Box
-
SKU: LEG-00292
Model: F01-SLS300111425
Condition: New-In-Box
-
SKU: LEG-00294
Model: F01-SLS300131925
Condition: New-In-Box