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 (11696, 81284, 179306, 46505, 46507, 46509, 46511, 46514, 18625, 18626, 20294, 21298, 21305, 21306, 16192, 16513, 16514, 14661, 14662, 14304, 14305, 17431, 17432, 17433, 17434, 17435)) 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,11696,81284,179306,46505,46507,46509,46511,46514,18625,18626,20294,21298,21305,21306,16192,16513,16514,14661,14662,14304,14305,17431,17432,17433,17434,17435)
-
SKU: AMM-19935
Model: 19935
Condition: New-In-Box
-
SKU: AMM-26886
Model: 26886
Condition: New-In-Box
-
SKU: AMM-26796
Model: 9781781452813
Condition: New-In-Box
-
SKU: AMM-24768
Model: 9781781451427
Condition: New-In-Box
-
SKU: AMM-24805
Model: 9781781451434
Condition: New-In-Box
-
SKU: AMM-25397
Model: 9781781452080
Condition: New-In-Box
-
SKU: AMM-25471
Model: 9781781452219
Condition: New-In-Box
-
SKU: AMM-25528
Model: 9781781452295
Condition: New-In-Box
-
SKU: AMM-23609
Model: 9781781451045
Condition: New-In-Box
-
SKU: AMM-23869
Model: 9781781451069
Condition: New-In-Box
-
SKU: AMM-24439
Model: 9781781451151
Condition: New-In-Box
-
SKU: AMM-21520
Model: 9781781450376
Condition: New-In-Box
-
SKU: AMM-22342
Model: 9781781450543
Condition: New-In-Box
-
SKU: AMM-22552
Model: 9781781450574
Condition: New-In-Box
-
SKU: AMM-20980
Model: 9781907708930
Condition: New-In-Box
-
SKU: AMM-21011
Model: 21011
Condition: New-In-Box
-
SKU: AMM-21365
Model: 9781907708961
Condition: New-In-Box
-
SKU: AMM-20762
Model: 9781907708855
Condition: New-In-Box
-
SKU: AMM-20761
Model: 9781907708862
Condition: New-In-Box
-
SKU: AMM-19544
Model: 9781907708343
Condition: New-In-Box
-
SKU: AMM-20226
Model: 9781907708541
Condition: New-In-Box
-
SKU: AMM-20462
Model: 9781907708763
Condition: New-In-Box
-
SKU: AMM-22267
Model: 9781781450512
Condition: New-In-Box
-
SKU: AMM-22692
Model: 9781781450635
Condition: New-In-Box
-
SKU: AMM-22834
Model: 9781781450697
Condition: New-In-Box
-
SKU: AMM-23287
Model: 9781781450963
Condition: New-In-Box