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 (204903, 216937, 9633, 120, 189, 61280, 65084, 65090, 65116, 18420, 81228, 81229, 82666, 85056, 90483, 210407, 216778, 216779, 216930, 216932, 216933, 216934, 216935, 216936, 216938, 216939, 216940, 216941, 224763, 122309)) 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,204903,216937,9633,120,189,61280,65084,65090,65116,18420,81228,81229,82666,85056,90483,210407,216778,216779,216930,216932,216933,216934,216935,216936,216938,216939,216940,216941,224763,122309)
-
SKU: AVE-00517
Model: F301
Condition: New-In-Box
-
SKU: AVE-00046D
Model: A2030D
Condition: New-In-Box
-
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-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-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
-
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
-
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-00046T
Model: A2030DCB
Condition: New-In-Box