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 (10023, 706, 1485, 61852, 61853, 61854, 61855, 20332, 17552, 85748, 91460, 91462, 91463, 93099, 93205, 95107, 95108, 95109, 96427, 99290, 120175, 152400, 162570, 162655, 162656, 162658, 162659, 177809, 10005, 10008)) 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,10023,706,1485,61852,61853,61854,61855,20332,17552,85748,91460,91462,91463,93099,93205,95107,95108,95109,96427,99290,120175,152400,162570,162655,162656,162658,162659,177809,10005,10008)
-
SKU: CHI-00164
Model: 4045
Condition: New-In-Box
-
SKU: CHI-00157
Model: 4025
Condition: New-In-Box
-
SKU: CHI-00165
Model: 4050
Condition: New-In-Box
-
SKU: CHI-03120
Model: 3120
Condition: New-In-Box
-
SKU: CHI-03520
Model: 3520
Condition: New-In-Box
-
SKU: CHI-03530
Model: 3530
Condition: New-In-Box
-
SKU: CHI-03560
Model: 3560
Condition: New-In-Box
-
SKU: CHI-00008
Model: 1045
Condition: New-In-Box
-
SKU: CHI-03545
Model: 3545
Condition: New-In-Box
-
SKU: CHI-00029J
Model: 1215
Condition: New-In-Box
-
SKU: CHI-05141
Model: 5141
Condition: New-In-Box
-
SKU: CHI-01110
Model: 1110
Condition: New-In-Box
-
SKU: CHI-01140
Model: 1140
Condition: New-In-Box
-
SKU: CHI-00166P
Model: 4060
Condition: New-In-Box
-
SKU: CHI-00107Q
Model: 2330QR
Condition: New-In-Box
-
SKU: CHI-001461A
Model: 3525
Condition: New-In-Box
-
SKU: CHI-001461K
Model: 3535
Condition: New-In-Box
-
SKU: CHI-00183
Model: 6030
Condition: New-In-Box
-
SKU: CHI-00090P
Model: 2188OP
Condition: New-In-Box
-
SKU: CHI-00120R
Model: 2490QR
Condition: New-In-Box
-
SKU: CHI-00052F
Model: 1655
Condition: New-In-Box
-
SKU: CHI-04016
Model: 4016
Condition: New-In-Box
-
SKU: CHI-00106
Model: 2330OP
Condition: New-In-Box
-
SKU: CHI-00021
Model: 1130
Condition: New-In-Box
-
SKU: CHI-00052
Model: 1650
Condition: New-In-Box
-
SKU: CHI-09213
Model: 9213
Condition: New-In-Box
-
SKU: CHI-8115LHZ
Model: 8115LHZ
Condition: New-In-Box
-
SKU: CHI-04065
Model: 4065
Condition: New-In-Box
-
SKU: CHI-00022
Model: 1135
Condition: New-In-Box
-
SKU: CHI-00028
Model: 1165
Condition: New-In-Box