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 (19610, 15809, 15810, 16248, 16523, 16528, 16529, 16530, 16531, 16583, 16584, 16585, 16586, 16587, 16588, 16589, 16590, 16842, 17591, 21743, 22290, 22291, 8581, 8582, 8584, 8585, 8586, 10917, 10918, 9406)) 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,19610,15809,15810,16248,16523,16528,16529,16530,16531,16583,16584,16585,16586,16587,16588,16589,16590,16842,17591,21743,22290,22291,8581,8582,8584,8585,8586,10917,10918,9406)
-
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
-
SKU: COU-00165
Model: 1285424832
Condition: New-In-Box
-
SKU: COU-00166
Model: 1285434625
Condition: New-In-Box
-
SKU: COU-00167
Model: 1285763095
Condition: New-In-Box
-
SKU: COU-00152
Model: 1285084510
Condition: New-In-Box
-
SKU: COU-00153
Model: 1285424811
Condition: New-In-Box
-
SKU: COU-00154
Model: 1285424576
Condition: New-In-Box
-
SKU: COU-00155
Model: 128542624
Condition: New-In-Box
-
SKU: COU-00157
Model: 1285434667
Condition: New-In-Box
-
SKU: COU-00158
Model: 1285428338
Condition: New-In-Box
-
SKU: COU-00159
Model: 1285446592
Condition: New-In-Box
-
SKU: COU-00160
Model: 1285084534
Condition: New-In-Box
-
SKU: COU-00168
Model: 9781285763118
Condition: New-In-Box
-
SKU: COU-00174
Model: 9781285429960
Condition: New-In-Box
-
SKU: COU-00175
Model: 9781305263574
Condition: New-In-Box
-
SKU: COU-00177
Model: 9781305114166
Condition: New-In-Box
-
SKU: COU-00178
Model: 9781285839165
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-00009
Model: 1435460287
Condition: New-In-Box
-
SKU: COU-00009F
Model: 1435460850
Condition: New-In-Box
-
SKU: COU-00002
Model: 1435454294
Condition: New-In-Box