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 (586858, 577268, 77758, 77761, 77762, 77763, 77764, 77765, 17823, 19318, 15934, 17445, 23887, 23888, 23889, 89725, 96519, 96520, 96521, 120543, 120573, 109603, 110208, 110209, 110657, 115335, 120542, 163895, 163896, 163899)) 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,586858,577268,77758,77761,77762,77763,77764,77765,17823,19318,15934,17445,23887,23888,23889,89725,96519,96520,96521,120543,120573,109603,110208,110209,110657,115335,120542,163895,163896,163899)
-
SKU: ELI-EL20942.2
Model: EL20942.2
Condition: New-In-Box
-
SKU: ELI-EL20941.1
Model: EL20941.1
Condition: New-In-Box
-
SKU: ELI-19371
Model: EL 19371
Condition: New-In-Box
-
SKU: ELI-26123
Model: EL 26123
Condition: New-In-Box
-
SKU: ELI-26129
Model: EL 26129
Condition: New-In-Box
-
SKU: ELI-26537
Model: EL 26537
Condition: New-In-Box
-
SKU: ELI-26538
Model: EL 26538
Condition: New-In-Box
-
SKU: ELI-28004
Model: EL 28004
Condition: New-In-Box
-
SKU: ELI-11003
Model: EL 11003
Condition: New-In-Box
-
SKU: ELI-11122
Model: 11122
Condition: New-In-Box
-
SKU: ELI-26232
Model: EL 26232
Condition: New-In-Box
-
SKU: ELI-31049
Model: ELI-31049
Condition: New-In-Box
-
SKU: ELI-20151
Model: EL20151
Condition: New-In-Box
-
SKU: ELI-26342
Model: EL26342
Condition: New-In-Box
-
SKU: ELI-26340
Model: EL26340
Condition: New-In-Box
-
SKU: ELI-26256
Model: EL26256
Condition: New-In-Box
-
SKU: ELI-19368
Model: EL 19368
Condition: New-In-Box
-
SKU: ELI-19369
Model: 19369
Condition: New-In-Box
-
SKU: ELI-19370
Model: 19370
Condition: New-In-Box
-
SKU: ELI-19367
Model: 19367
Condition: New-In-Box
-
SKU: ELI-19372
Model: 19372
Condition: New-In-Box
-
SKU: ELI-28005
Model: EL28005
Condition: New-In-Box
-
SKU: ELI-10305.1
Model: 10305.1
Condition: New-In-Box
-
SKU: ELI-10306.1
Model: 10306.1
Condition: New-In-Box
-
SKU: ELI-26080
Model: EL 26080
Condition: New-In-Box
-
SKU: ELI-26348
Model: EL26348
Condition: New-In-Box
-
SKU: ELI-19366
Model: 19366
Condition: New-In-Box
-
SKU: ELI-20847.2
Model: EL20847.2
Condition: New-In-Box
-
SKU: ELI-24084
Model: EL 24084
Condition: New-In-Box
-
SKU: ELI-26168
Model: EL 26168
Condition: New-In-Box