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 (9633, 120, 189, 204903, 216937, 192152, 13857, 13865, 13866, 13867, 9613, 9614, 9615, 9616, 9617, 9618, 9619, 9620, 9621, 9622, 9623, 9624, 9625, 9626, 9627, 9635, 75, 76, 77, 78)) 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,9633,120,189,204903,216937,192152,13857,13865,13866,13867,9613,9614,9615,9616,9617,9618,9619,9620,9621,9622,9623,9624,9625,9626,9627,9635,75,76,77,78)
-
SKU: AVE-00516
Model: F825
Condition: New-In-Box
-
SKU: AVE-00300
Model: D200
Condition: New-In-Box
-
SKU: AVE-00316
Model: D400
Condition: New-In-Box
-
SKU: AVE-00517
Model: F301
Condition: New-In-Box
-
SKU: AVE-00046D
Model: A2030D
Condition: New-In-Box
-
SKU: AVE-00301
Model: A0030B
Condition: New-In-Box
-
SKU: AVE-00047E
Model: A2030DKIT
Condition: New-In-Box
-
SKU: AVE-00260
Model: C4460
Condition: New-In-Box
-
SKU: AVE-00262
Model: C4461
Condition: New-In-Box
-
SKU: AVE-00266
Model: C4464
Condition: New-In-Box
-
SKU: AVE-00029
Model: A5036CS
Condition: New-In-Box
-
SKU: AVE-00040
Model: A2025F
Condition: New-In-Box
-
SKU: AVE-00046
Model: A0035CS
Condition: New-In-Box
-
SKU: AVE-00048
Model: A2033LCB
Condition: New-In-Box
-
SKU: AVE-00190
Model: C100
Condition: New-In-Box
-
SKU: AVE-00310
Model: D230
Condition: New-In-Box
-
SKU: AVE-00311
Model: D260
Condition: New-In-Box
-
SKU: AVE-00319
Model: D500
Condition: New-In-Box
-
SKU: AVE-00322
Model: D520L
Condition: New-In-Box
-
SKU: AVE-00420
Model: E650
Condition: New-In-Box
-
SKU: AVE-00502
Model: F1100
Condition: New-In-Box
-
SKU: AVE-00509
Model: F808
Condition: New-In-Box
-
SKU: AVE-00510
Model: F809
Condition: New-In-Box
-
SKU: AVE-00514
Model: F820
Condition: New-In-Box
-
SKU: AVE-00515
Model: F820TH
Condition: New-In-Box
-
SKU: AVE-00520
Model: F830
Condition: New-In-Box
-
SKU: AVE-00044
Model: A2033F
Condition: New-In-Box
-
SKU: AVE-00200
Model: C1000
Condition: New-In-Box
-
SKU: AVE-00202
Model: C1005
Condition: New-In-Box
-
SKU: AVE-00208
Model: C155
Condition: New-In-Box