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 (20710, 20753, 20754, 20765, 20766, 20769, 20891, 20894, 20895, 20897, 20898, 20899, 20900, 20901, 20902, 20903, 20904, 20905, 20906, 20907, 20908, 20909, 20910, 20913, 20914, 20916, 20917, 20919, 20925, 20928)) 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,20710,20753,20754,20765,20766,20769,20891,20894,20895,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20913,20914,20916,20917,20919,20925,20928)
-
SKU: AQU-12310
Model: 12310
Condition: New-In-Box
-
SKU: AQU-10716
Model: 10716
Condition: New-In-Box
-
SKU: AQU-10720
Model: 10720
Condition: New-In-Box
-
SKU: AQU-10912
Model: 10912
Condition: New-In-Box
-
SKU: AQU-10959
Model: 10959
Condition: New-In-Box
-
SKU: AQU-10992
Model: 10992
Condition: New-In-Box
-
SKU: AQU-10102
Model: 10102
Condition: New-In-Box
-
SKU: AQU-10701
Model: 10701
Condition: New-In-Box
-
SKU: AQU-10702
Model: 10702
Condition: New-In-Box
-
SKU: AQU-10802
Model: 10802
Condition: New-In-Box
-
SKU: AQU-10704
Model: 10704
Condition: New-In-Box
-
SKU: AQU-10705
Model: 10705
Condition: New-In-Box
-
SKU: AQU-10708
Model: 10708
Condition: New-In-Box
-
SKU: AQU-10709
Model: 10709
Condition: New-In-Box
-
SKU: AQU-10712
Model: 10712
Condition: New-In-Box
-
SKU: AQU-10711
Model: 10711
Condition: New-In-Box
-
SKU: AQU-10805
Model: 10805
Condition: New-In-Box
-
SKU: AQU-10715
Model: 10715
Condition: New-In-Box
-
SKU: AQU-10706
Model: 10706
Condition: New-In-Box
-
SKU: AQU-10707
Model: 10707
Condition: New-In-Box
-
SKU: AQU-10901
Model: 10901
Condition: New-In-Box
-
SKU: AQU-10902
Model: 10902
Condition: New-In-Box
-
SKU: AQU-10903
Model: 10903
Condition: New-In-Box
-
SKU: AQU-10904
Model: 10904
Condition: New-In-Box
-
SKU: AQU-10950
Model: 10950
Condition: New-In-Box
-
SKU: AQU-10952
Model: 10952
Condition: New-In-Box
-
SKU: AQU-10953
Model: 10953
Condition: New-In-Box
-
SKU: AQU-12010
Model: 12010
Condition: New-In-Box
-
SKU: AQU-12105
Model: 12105
Condition: New-In-Box
-
SKU: AQU-11202
Model: 11202
Condition: New-In-Box