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 (13954, 13955, 13956, 15513, 7277, 9567, 9575, 9579, 9580, 9581, 9591, 50, 51, 55, 68, 69, 83, 84, 108, 109, 318821, 233159, 233160, 233161, 233162, 20710, 20753, 20754, 20765, 20766)) 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,13954,13955,13956,15513,7277,9567,9575,9579,9580,9581,9591,50,51,55,68,69,83,84,108,109,318821,233159,233160,233161,233162,20710,20753,20754,20765,20766)
-
SKU: AQU-01322
Model: 1322
Condition: New-In-Box
-
SKU: AQU-01323
Model: 1323
Condition: New-In-Box
-
SKU: AQU-01324
Model: 1324
Condition: New-In-Box
-
SKU: AQU-01632
Model: 1632
Condition: New-In-Box
-
SKU: AQU-01755
Model: 1755
Condition: New-In-Box
-
SKU: AQU-01243
Model: 1243
Condition: New-In-Box
-
SKU: AQU-01263
Model: 1263
Condition: New-In-Box
-
SKU: AQU-01318
Model: 1318
Condition: New-In-Box
-
SKU: AQU-01319
Model: 1319
Condition: New-In-Box
-
SKU: AQU-01320
Model: 1320
Condition: New-In-Box
-
SKU: AQU-01741
Model: 1741
Condition: New-In-Box
-
SKU: AQU-01350
Model: 1350
Condition: New-In-Box
-
SKU: AQU-01353
Model: 1353
Condition: New-In-Box
-
SKU: AQU-01401
Model: 1401
Condition: New-In-Box
-
SKU: AQU-01753
Model: 1753
Condition: New-In-Box
-
SKU: AQU-01754
Model: 1754
Condition: New-In-Box
-
SKU: AQU-01260
Model: 1260
Condition: New-In-Box
-
SKU: AQU-01261
Model: 1261
Condition: New-In-Box
-
SKU: AQU-01751
Model: 1751
Condition: New-In-Box
-
SKU: AQU-01752
Model: 1752
Condition: New-In-Box
-
SKU: HAS-UNDERWATER
Model: UNDERWATER
Condition: New-In-Box
-
SKU: AQU-10139
Model: 10139
Condition: New-In-Box
-
SKU: AQU-10724
Model: 10724
Condition: New-In-Box
-
SKU: AQU-10997
Model: 10997
Condition: New-In-Box
-
SKU: AQU-12019
Model: 12019
Condition: New-In-Box
-
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