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, 228149, 228150, 228151, 228152, 228153, 228154, 228155, 228158, 228160, 228161, 228162, 228193, 228253, 228254, 228255, 228256, 228257, 228258, 228260, 228261, 228262, 228265, 228266, 228267, 228268, 228269, 228270, 228271, 145089)) 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,228149,228150,228151,228152,228153,228154,228155,228158,228160,228161,228162,228193,228253,228254,228255,228256,228257,228258,228260,228261,228262,228265,228266,228267,228268,228269,228270,228271,145089)
-
SKU: CPH-25007
Model: C110025007
Condition: New-In-Box
-
SKU: CPH-05013
Model: C012005013
Condition: New-In-Box
-
SKU: CPH-05014
Model: C012005014
Condition: New-In-Box
-
SKU: CPH-05034
Model: C012005034
Condition: New-In-Box
-
SKU: CPH-05035
Model: C012005035
Condition: New-In-Box
-
SKU: CPH-05073
Model: C012005073
Condition: New-In-Box
-
SKU: CPH-05074
Model: C012005074
Condition: New-In-Box
-
SKU: CPH-06074
Model: C012006074
Condition: New-In-Box
-
SKU: CPH-003006
Model: C011003006
Condition: New-In-Box
-
SKU: CPH-25006
Model: C011025006
Condition: New-In-Box
-
SKU: CPH-32055
Model: C011032055
Condition: New-In-Box
-
SKU: CPH-32056
Model: C011032056
Condition: New-In-Box
-
SKU: CPH-003005
Model: C011003005
Condition: New-In-Box
-
SKU: CPH-04002
Model: C110004002
Condition: New-In-Box
-
SKU: CPH-04004
Model: C110004004
Condition: New-In-Box
-
SKU: CPH-10042
Model: C110010042
Condition: New-In-Box
-
SKU: CPH-10044
Model: C110010044
Condition: New-In-Box
-
SKU: CPH-10052
Model: C110010052
Condition: New-In-Box
-
SKU: CPH-10054
Model: C110010054
Condition: New-In-Box
-
SKU: CPH-25057
Model: C110025057
Condition: New-In-Box
-
SKU: CPH-26032
Model: C110026032
Condition: New-In-Box
-
SKU: CPH-26034
Model: C110026034
Condition: New-In-Box
-
SKU: CPH-07007
Model: C080007007
Condition: New-In-Box
-
SKU: CPH-07067
Model: C080007067
Condition: New-In-Box
-
SKU: CPH-16034
Model: C110016034
Condition: New-In-Box
-
SKU: CPH-16067
Model: C080016067
Condition: New-In-Box
-
SKU: CPH-19004
Model: C110019004
Condition: New-In-Box
-
SKU: CPH-200074
Model: C110020074
Condition: New-In-Box
-
SKU: CPH-25077
Model: C110025077
Condition: New-In-Box
-
SKU: CPH-29077
Model: C011025006
Condition: New-In-Box