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 (140857, 140858, 140859, 140860, 140861, 140862, 140863, 140865, 112350, 112351, 112352, 112353, 112354, 112355, 112380, 112381, 112382, 112383, 112391, 112392, 112393, 112394, 112395, 112396, 112397, 112398, 112399, 112428, 112429, 112430)) 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,140857,140858,140859,140860,140861,140862,140863,140865,112350,112351,112352,112353,112354,112355,112380,112381,112382,112383,112391,112392,112393,112394,112395,112396,112397,112398,112399,112428,112429,112430)
-
SKU: CPH-04006
Model: C03100406
Condition: New-In-Box
-
SKU: CPH-10036
Model: C011010036
Condition: New-In-Box
-
SKU: CPH-22002
Model: C01102200
Condition: New-In-Box
-
SKU: CPH-26012
Model: C011026012
Condition: New-In-Box
-
SKU: CPH-28005
Model: C011028005
Condition: New-In-Box
-
SKU: CPH-28006
Model: C011028006
Condition: New-In-Box
-
SKU: CPH-29076
Model: C011029076
Condition: New-In-Box
-
SKU: CPH-04046
Model: C031004046
Condition: New-In-Box
-
SKU: CPH-02002
Model: C012002002
Condition: New-In-Box
-
SKU: CPH-02004
Model: C012002004
Condition: New-In-Box
-
SKU: CPH-03002
Model: C012003002
Condition: New-In-Box
-
SKU: CPH-03003
Model: C012003003
Condition: New-In-Box
-
SKU: CPH-03004
Model: C012003004
Condition: New-In-Box
-
SKU: CPH-03005
Model: C012003005
Condition: New-In-Box
-
SKU: CPH-26013
Model: C011026013
Condition: New-In-Box
-
SKU: CPH-26014
Model: C011026014
Condition: New-In-Box
-
SKU: CPH-26015
Model: C011026015
Condition: New-In-Box
-
SKU: CPH-26016
Model: C011026016
Condition: New-In-Box
-
SKU: CPH-22003
Model: C011022003
Condition: New-In-Box
-
SKU: CPH-22004
Model: C011022004
Condition: New-In-Box
-
SKU: CPH-22005
Model: C011022005
Condition: New-In-Box
-
SKU: CPH-23003
Model: C011023003
Condition: New-In-Box
-
SKU: CPH-23004
Model: C011023004
Condition: New-In-Box
-
SKU: CPH-23005
Model: C011023005
Condition: New-In-Box
-
SKU: CPH-23006
Model: C011023006
Condition: New-In-Box
-
SKU: CPH-22006
Model: C011022006
Condition: New-In-Box
-
SKU: CPH-25003
Model: C011025003
Condition: New-In-Box
-
SKU: CPH-20073
Model: C011020073
Condition: New-In-Box
-
SKU: CPH-20074
Model: C011020074
Condition: New-In-Box
-
SKU: CPH-20075
Model: C011020075
Condition: New-In-Box