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 (12304, 12307, 12308, 12311, 12319, 4915, 4917, 4921, 4933, 4935, 4941, 4943, 4944, 4948, 4950, 4971, 4972, 4973, 4974, 4975, 4976, 4977, 4979, 5010, 5011, 5052, 5057, 5089, 5090, 6644)) 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,12304,12307,12308,12311,12319,4915,4917,4921,4933,4935,4941,4943,4944,4948,4950,4971,4972,4973,4974,4975,4976,4977,4979,5010,5011,5052,5057,5089,5090,6644)
-
SKU: WES-03502
Model: 3502
Condition: New-In-Box
-
SKU: WES-01937
Model: 1937
Condition: New-In-Box
-
SKU: WES-01935
Model: 1935
Condition: New-In-Box
-
SKU: WES-01032
Model: 1032
Condition: New-In-Box
-
SKU: WES-00301
Model: 301
Condition: New-In-Box
-
SKU: WES-00131
Model: 131
Condition: New-In-Box
-
SKU: WES-00201
Model: 201
Condition: New-In-Box
-
SKU: WES-00304
Model: 304
Condition: New-In-Box
-
SKU: WES-01022
Model: 1022
Condition: New-In-Box
-
SKU: WES-01031
Model: 1031
Condition: New-In-Box
-
SKU: WES-01203
Model: 1203
Condition: New-In-Box
-
SKU: WES-01303
Model: 1303
Condition: New-In-Box
-
SKU: WES-01304
Model: 1304
Condition: New-In-Box
-
SKU: WES-01503
Model: 1503
Condition: New-In-Box
-
SKU: WES-01703
Model: 1703
Condition: New-In-Box
-
SKU: WES-01934
Model: 1934
Condition: New-In-Box
-
SKU: WES-02002
Model: 2002
Condition: New-In-Box
-
SKU: WES-02003
Model: 2003
Condition: New-In-Box
-
SKU: WES-02011
Model: 2011
Condition: New-In-Box
-
SKU: WES-02012
Model: 2012
Condition: New-In-Box
-
SKU: WES-02021
Model: 2021
Condition: New-In-Box
-
SKU: WES-02026
Model: 2026
Condition: New-In-Box
-
SKU: WES-02200
Model: 2200
Condition: New-In-Box
-
SKU: WES-02460
Model: 2460
Condition: New-In-Box
-
SKU: WES-02461
Model: 2461
Condition: New-In-Box
-
SKU: WES-04834
Model: 4834
Condition: New-In-Box
-
SKU: WES-05015
Model: 5015
Condition: New-In-Box
-
SKU: WES-09014
Model: 9014
Condition: New-In-Box
-
SKU: WES-09908
Model: 9908
Condition: New-In-Box
-
SKU: WES-00130
Model: 130
Condition: New-In-Box