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 (488260, 488262, 488264, 488265, 488266, 488267, 488270, 488275, 488277, 488289, 513206, 515730, 515868, 515873, 516072, 241409, 241410, 241411, 250149, 250150, 262986, 262987, 262990, 264316, 265690, 268294, 270041, 272127, 276964, 277714)) 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,488260,488262,488264,488265,488266,488267,488270,488275,488277,488289,513206,515730,515868,515873,516072,241409,241410,241411,250149,250150,262986,262987,262990,264316,265690,268294,270041,272127,276964,277714)
-
SKU: WES-04790
Model: 4790
Condition: New-In-Box
-
SKU: WES-04796
Model: 4796
Condition: New-In-Box
-
SKU: WES-04732
Model: 4732
Condition: New-In-Box
-
SKU: WES-04733
Model: 4733
Condition: New-In-Box
-
SKU: WES-04785
Model: 4785
Condition: New-In-Box
-
SKU: WES-04788
Model: 4788
Condition: New-In-Box
-
SKU: WES-04782
Model: 4782
Condition: New-In-Box
-
SKU: WES-04712M
Model: 4712M
Condition: New-In-Box
-
SKU: WES-04713M
Model: 4713M
Condition: New-In-Box
-
SKU: WES-04771M
Model: 4771M
Condition: New-In-Box
-
SKU: WES-04780
Model: 4780
Condition: New-In-Box
-
SKU: WES-00162
Model: 162
Condition: New-In-Box
-
SKU: WES-00167
Model: 167
Condition: New-In-Box
-
SKU: WES-00169
Model: 169
Condition: New-In-Box
-
SKU: WES-00847S
Model: 847S
Condition: New-In-Box
-
SKU: WES-02831
Model: 2831
Condition: New-In-Box
-
SKU: WES-02835
Model: 2835
Condition: New-In-Box
-
SKU: WES-02836
Model: 2836
Condition: New-In-Box
-
SKU: WES-07583
Model: 7583
Condition: New-In-Box
-
SKU: WES-07585
Model: 7585
Condition: New-In-Box
-
SKU: WES-04700
Model: 4700
Condition: New-In-Box
-
SKU: WES-04702
Model: 4702
Condition: New-In-Box
-
SKU: WES-04711
Model: 4711
Condition: New-In-Box
-
SKU: WES-07611
Model: 7611
Condition: New-In-Box
-
SKU: WES-02080
Model: 2080
Condition: New-In-Box
-
SKU: WES-04520
Model: 4520
Condition: New-In-Box
-
SKU: WES-07638
Model: 7638
Condition: New-In-Box
-
SKU: WES-07657
Model: 7657
Condition: New-In-Box
-
SKU: WES-02839
Model: 2839
Condition: New-In-Box
-
SKU: WES-04999
Model: 4999
Condition: New-In-Box