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 (266276, 112350, 112351, 112352, 112353, 112354, 112355, 112380, 112381, 112382, 112383, 112391, 112392, 112393, 112394, 112395, 112396, 112397, 112398, 112399, 112428, 112429, 112430, 112431, 112432, 112433, 112434, 112435, 112461, 112462)) 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,266276,112350,112351,112352,112353,112354,112355,112380,112381,112382,112383,112391,112392,112393,112394,112395,112396,112397,112398,112399,112428,112429,112430,112431,112432,112433,112434,112435,112461,112462)
-
SKU: CPH-25007
Model: C110025007
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
-
SKU: CPH-24043
Model: C011024003
Condition: New-In-Box
-
SKU: CPH-24044
Model: C011024004
Condition: New-In-Box
-
SKU: CPH-24045
Model: C011024005
Condition: New-In-Box
-
SKU: CPH-25004
Model: C011025004
Condition: New-In-Box
-
SKU: CPH-25005
Model: C011025005
Condition: New-In-Box
-
SKU: CPH-10033
Model: C011010033
Condition: New-In-Box
-
SKU: CPH-10034
Model: C011010034
Condition: New-In-Box