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 (10917, 10918, 8581, 8582, 8584, 8585, 8586, 9406, 9407, 9408, 9410, 9413, 9414, 9415, 9416, 9418, 9419, 9420, 9421, 9423, 9424, 9425, 852, 17591, 19610, 15809, 15810, 16248, 16523, 16528)) 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,10917,10918,8581,8582,8584,8585,8586,9406,9407,9408,9410,9413,9414,9415,9416,9418,9419,9420,9421,9423,9424,9425,852,17591,19610,15809,15810,16248,16523,16528)
-
SKU: COU-00009
Model: 1435460287
Condition: New-In-Box
-
SKU: COU-00009F
Model: 1435460850
Condition: New-In-Box
-
SKU: COU-00008E
Model: 1435457362
Condition: New-In-Box
-
SKU: COU-00008H
Model: 1435458789
Condition: New-In-Box
-
SKU: COU-00008P
Model: 1435459380
Condition: New-In-Box
-
SKU: COU-00008S
Model: 1435459427
Condition: New-In-Box
-
SKU: COU-00008V
Model: 1435459441
Condition: New-In-Box
-
SKU: COU-00002
Model: 1435454294
Condition: New-In-Box
-
SKU: COU-00002G
Model: 1435454330
Condition: New-In-Box
-
SKU: COU-00003
Model: 1435454347
Condition: New-In-Box
-
SKU: COU-00008
Model: 1435456914
Condition: New-In-Box
-
SKU: COU-00060
Model: 1598630261
Condition: New-In-Box
-
SKU: COU-00100
Model: 1598634542
Condition: New-In-Box
-
SKU: COU-00105
Model: 1598635298
Condition: New-In-Box
-
SKU: COU-00110
Model: 1598635344
Condition: New-In-Box
-
SKU: COU-00115
Model: 1598635484
Condition: New-In-Box
-
SKU: COU-00120
Model: 1598635697
Condition: New-In-Box
-
SKU: COU-00125
Model: 1598635778
Condition: New-In-Box
-
SKU: COU-00128
Model: 1598639056
Condition: New-In-Box
-
SKU: COU-00135
Model: 1598639048
Condition: New-In-Box
-
SKU: COU-00140
Model: 1598639927
Condition: New-In-Box
-
SKU: COU-00150
Model: 1598639951
Condition: New-In-Box
-
SKU: COU-00005
Model: 1435456319
Condition: New-In-Box
-
SKU: COU-00174
Model: 9781285429960
Condition: New-In-Box
-
SKU: COU-00176
Model: 9781305577275
Condition: New-In-Box
-
SKU: COU-00161
Model: 9781285759838
Condition: New-In-Box
-
SKU: COU-00162
Model: 9781285084589
Condition: New-In-Box
-
SKU: COU-00151
Model: 9781285424606
Condition: New-In-Box
-
SKU: COU-00163
Model: 9781285759876
Condition: New-In-Box
-
SKU: COU-00164
Model: 1285422732
Condition: New-In-Box