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 (112465, 112466, 112467, 112468, 112469, 112470, 112471, 112472, 112494, 112495, 112496, 112497, 112498, 112499, 112500, 112501, 112502, 112503, 112518, 112519, 112520, 112521, 112522, 112523, 112524, 112525, 112526, 112527, 112529, 112530)) 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,112465,112466,112467,112468,112469,112470,112471,112472,112494,112495,112496,112497,112498,112499,112500,112501,112502,112503,112518,112519,112520,112521,112522,112523,112524,112525,112526,112527,112529,112530)
-
SKU: CPH-17054
Model: C011017054
Condition: New-In-Box
-
SKU: CPH-17055
Model: C011017055
Condition: New-In-Box
-
SKU: CPH-17063
Model: C011017063
Condition: New-In-Box
-
SKU: CPH-17064
Model: C011017064
Condition: New-In-Box
-
SKU: CPH-17065
Model: C011017065
Condition: New-In-Box
-
SKU: CPH-18073
Model: C011018073
Condition: New-In-Box
-
SKU: CPH-18074
Model: C011018074
Condition: New-In-Box
-
SKU: CPH-18075
Model: C011018075
Condition: New-In-Box
-
SKU: CPH-04034
Model: C031004034
Condition: New-In-Box
-
SKU: CPH-04035
Model: C031004034
Condition: New-In-Box
-
SKU: CPH-04044
Model: C031004034
Condition: New-In-Box
-
SKU: CPH-04045
Model: C031004034
Condition: New-In-Box
-
SKU: CPH-08073
Model: C011008073
Condition: New-In-Box
-
SKU: CPH-08074
Model: C011008074
Condition: New-In-Box
-
SKU: CPH-08075
Model: C011008075
Condition: New-In-Box
-
SKU: CPH-09003
Model: C011009003
Condition: New-In-Box
-
SKU: CPH-09004
Model: C011009004
Condition: New-In-Box
-
SKU: CPH-09005
Model: C011009005
Condition: New-In-Box
-
SKU: CPH-01003
Model: C110001003
Condition: New-In-Box
-
SKU: CPH-01063
Model: C110001063
Condition: New-In-Box
-
SKU: CPH-01083
Model: C110001003
Condition: New-In-Box
-
SKU: CPH-02077
Model: C110002077
Condition: New-In-Box
-
SKU: CPH-06037
Model: C060006037
Condition: New-In-Box
-
SKU: CPH-12004
Model: C031002004
Condition: New-In-Box
-
SKU: CPH-12005
Model: C031002005
Condition: New-In-Box
-
SKU: CPH-15037
Model: C060015037
Condition: New-In-Box
-
SKU: CPH-15047
Model: C060015047
Condition: New-In-Box
-
SKU: CPH-20047
Model: C060020047
Condition: New-In-Box
-
SKU: CPH-02007
Model: C110002007
Condition: New-In-Box
-
SKU: CPH-02087
Model: C110002087
Condition: New-In-Box