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 (163900, 334121, 14089, 14399, 14603, 14604, 16012, 7341, 7342, 7343, 7344, 11586, 11587, 11590, 11591, 12180, 12181, 12409, 12411, 12412, 9628, 1360, 18801, 18802, 23893, 23901, 219211, 222003, 235670, 108286)) 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,163900,334121,14089,14399,14603,14604,16012,7341,7342,7343,7344,11586,11587,11590,11591,12180,12181,12409,12411,12412,9628,1360,18801,18802,23893,23901,219211,222003,235670,108286)
-
SKU: HOO-01262
Model: HEYES
Condition: New-In-Box
-
SKU: HOO-02603
Model: CFEX512
Condition: New-In-Box
-
SKU: HOO-02140
Model: RAWSDHC32GBU1
Condition: New-In-Box
-
SKU: HOO-02150
Model: RAWSDXC64GBU1
Condition: New-In-Box
-
SKU: HOO-02030
Model: HS7CF32
Condition: New-In-Box
-
SKU: HOO-02040
Model: HS7CF64
Condition: New-In-Box
-
SKU: HOO-01351
Model: HCP
Condition: New-In-Box
-
SKU: HOO-01240
Model: H-EYEC22
Condition: New-In-Box
-
SKU: HOO-01230
Model: H-EYEC18L
Condition: New-In-Box
-
SKU: HOO-01224
Model: H-EYEC18
Condition: New-In-Box
-
SKU: HOO-01246
Model: H-EYEN22R
Condition: New-In-Box
-
SKU: HOO-01243
Model: H-EYEC22G
Condition: New-In-Box
-
SKU: HOO-01233
Model: H-EYEC18L
Condition: New-In-Box
-
SKU: HOO-01256
Model: H-EYEN22RG
Condition: New-In-Box
-
SKU: HOO-01260
Model: H-EYEN22SG
Condition: New-In-Box
-
SKU: HOO-01375
Model: HMAG3.0
Condition: New-In-Box
-
SKU: HOO-01360
Model: HGEC1
Condition: New-In-Box
-
SKU: HOO-01210
Model: H-400
Condition: New-In-Box
-
SKU: HOO-01380
Model: HSLRM
Condition: New-In-Box
-
SKU: HOO-01249
Model: H-EYEN22S
Condition: New-In-Box
-
SKU: HOO-01350
Model: HCRN
Condition: New-In-Box
-
SKU: HOO-01345
Model: HCKP
Condition: New-In-Box
-
SKU: HOO-01311
Model: HLPP3M
Condition: New-In-Box
-
SKU: HOO-01390
Model: HTE
Condition: New-In-Box
-
SKU: HOO-02412
Model: HUSB3
Condition: New-In-Box
-
SKU: HOO-02320
Model: HM1064
Condition: New-In-Box
-
SKU: HOO-02041
Model: HS7CF128
Condition: New-In-Box
-
SKU: HOO-02416
Model: STEEL31
Condition: New-In-Box
-
SKU: HOO-01354
Model: HD350
Condition: New-In-Box
-
SKU: HOO-01377
Model: HRSA
Condition: New-In-Box