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 (123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 181, 182, 183, 184, 185, 186, 187, 190, 191, 192, 194, 195, 196, 260482, 210407, 216778, 216779, 216930, 216932)) 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,123,124,125,126,127,128,129,130,131,132,133,181,182,183,184,185,186,187,190,191,192,194,195,196,260482,210407,216778,216779,216930,216932)
-
SKU: AVE-00318
Model: D420
Condition: New-In-Box
-
SKU: AVE-00320
Model: D500LB
Condition: New-In-Box
-
SKU: AVE-00328
Model: D600
Condition: New-In-Box
-
SKU: AVE-00330
Model: D600CB
Condition: New-In-Box
-
SKU: AVE-00332
Model: D650
Condition: New-In-Box
-
SKU: AVE-00402
Model: E200
Condition: New-In-Box
-
SKU: AVE-00403
Model: E250
Condition: New-In-Box
-
SKU: AVE-00404
Model: E600
Condition: New-In-Box
-
SKU: AVE-00500
Model: F1000
Condition: New-In-Box
-
SKU: AVE-00506
Model: F800
Condition: New-In-Box
-
SKU: AVE-00508
Model: F805
Condition: New-In-Box
-
SKU: AVE-00212
Model: C1575B
Condition: New-In-Box
-
SKU: AVE-00218
Model: C337
Condition: New-In-Box
-
SKU: AVE-00220
Model: C338
Condition: New-In-Box
-
SKU: AVE-00222
Model: C500
Condition: New-In-Box
-
SKU: AVE-00302
Model: D200B
Condition: New-In-Box
-
SKU: AVE-00304
Model: D210
Condition: New-In-Box
-
SKU: AVE-00312
Model: D340
Condition: New-In-Box
-
SKU: AVE-00324
Model: D520LB
Condition: New-In-Box
-
SKU: AVE-00334
Model: D700B
Condition: New-In-Box
-
SKU: AVE-00336
Model: D705B
Condition: New-In-Box
-
SKU: AVE-00406
Model: E600C
Condition: New-In-Box
-
SKU: AVE-00504
Model: F300
Condition: New-In-Box
-
SKU: AVE-00512
Model: F810
Condition: New-In-Box
-
SKU: AVE-00021
Model: A2014
Condition: New-In-Box
-
SKU: AVE-00023
Model: A2016D
Condition: New-In-Box
-
SKU: AVE-00013B
Model: A0025B
Condition: New-In-Box
-
SKU: AVE-00014B
Model: A0035B
Condition: New-In-Box
-
SKU: AVE-00010
Model: A0030CS
Condition: New-In-Box
-
SKU: AVE-00024
Model: A630B
Condition: New-In-Box