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 (216933, 216934, 216935, 216936, 216938, 216939, 216940, 216941, 224763, 141249, 166018, 178487, 189694, 190966, 61280, 65084, 65090, 65116, 18420, 17328, 17329, 13857, 13865, 13866, 13867, 81228, 81229, 82666, 85056, 90483)) 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,216933,216934,216935,216936,216938,216939,216940,216941,224763,141249,166018,178487,189694,190966,61280,65084,65090,65116,18420,17328,17329,13857,13865,13866,13867,81228,81229,82666,85056,90483)
-
SKU: AVE-00026
Model: A635B
Condition: New-In-Box
-
SKU: AVE-00027
Model: A1010CS
Condition: New-In-Box
-
SKU: AVE-00030
Model: A5043
Condition: New-In-Box
-
SKU: AVE-00045
Model: A2033FKIT
Condition: New-In-Box
-
SKU: AVE-00046F
Model: A2018F
Condition: New-In-Box
-
SKU: AVE-00047
Model: A2030DCBKIT
Condition: New-In-Box
-
SKU: AVE-00050
Model: A3058CS
Condition: New-In-Box
-
SKU: AVE-00075
Model: A5029
Condition: New-In-Box
-
SKU: AVE-01045
Model: A1045CS
Condition: New-In-Box
-
SKU: AVE-00221
Model: C345
Condition: New-In-Box
-
SKU: AVE-00028C
Model: A5034
Condition: New-In-Box
-
SKU: AVE-00046C
Model: A2018FCB
Condition: New-In-Box
-
SKU: AVE-00700
Model: A5033
Condition: New-In-Box
-
SKU: AVE-00009
Model: A0010
Condition: New-In-Box
-
SKU: AVE-00552
Model: G100-2
Condition: New-In-Box
-
SKU: AVE-00029R
Model: A5042CS
Condition: New-In-Box
-
SKU: AVE-00047F
Model: A2033FCB
Condition: New-In-Box
-
SKU: AVE-00047L
Model: A2033L
Condition: New-In-Box
-
SKU: AVE-00403L
Model: E390
Condition: New-In-Box
-
SKU: AVE-00080
Model: A9000N
Condition: New-In-Box
-
SKU: AVE-00081
Model: A9000NB
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-00046A
Model: A2016DCB
Condition: New-In-Box
-
SKU: AVE-00120
Model: B6039CS
Condition: New-In-Box
-
SKU: AVE-00045B
Model: A2033FCBKIT
Condition: New-In-Box
-
SKU: AVE-00028
Model: A5017
Condition: New-In-Box
-
SKU: AVE-00027A
Model: A1020CS
Condition: New-In-Box