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 (598669, 588444, 338136, 6081, 6082, 6083, 6084, 6086, 6087, 4064, 4065, 4066, 4084, 4085, 4086, 367146, 367148, 367152, 367157, 367159, 243048, 313454, 203732, 204935, 221746, 222215, 222216, 222217, 134240, 135853)) 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,598669,588444,338136,6081,6082,6083,6084,6086,6087,4064,4065,4066,4084,4085,4086,367146,367148,367152,367157,367159,243048,313454,203732,204935,221746,222215,222216,222217,134240,135853)
-
SKU: SHU-SRH440A
Model: SRH440A
Condition: New-In-Box
-
SKU: SHU-00095
Model: PGA48-LC
Condition: New-In-Box
-
SKU: SHU-00238
Model: MV5C-USB
Condition: New-In-Box
-
SKU: SHU-00010C
Model: A15AS
Condition: New-In-Box
-
SKU: SHU-00020D
Model: BETA 57A
Condition: New-In-Box
-
SKU: SHU-00020J
Model: BETA 87C
Condition: New-In-Box
-
SKU: SHU-00040J
Model: SM58-LC
Condition: New-In-Box
-
SKU: SHU-00050E
Model: VP64A
Condition: New-In-Box
-
SKU: SHU-00060A
Model: SRH840
Condition: New-In-Box
-
SKU: SHU-00020E
Model: BETA 58A
Condition: New-In-Box
-
SKU: SHU-00020G
Model: BETA 87A
Condition: New-In-Box
-
SKU: SHU-00040E
Model: SM57-LC
Condition: New-In-Box
-
SKU: SHU-00040G
Model: SM58-CN
Condition: New-In-Box
-
SKU: SHU-00040L
Model: SM58S
Condition: New-In-Box
-
SKU: SHU-00060
Model: SRH440
Condition: New-In-Box
-
SKU: SHU-00264
Model: SLXD24D/B58
Condition: New-In-Box
-
SKU: SHU-00265
Model: SBC203-US
Condition: New-In-Box
-
SKU: SHU-00266
Model: SB903
Condition: New-In-Box
-
SKU: SHU-00267
Model: UA844+SWB
Condition: New-In-Box
-
SKU: SHU-00268
Model: WA371
Condition: New-In-Box
-
SKU: SHU-00045
Model: VP64AL
Condition: New-In-Box
-
SKU: SHU-0MX185
Model: MX185
Condition: New-In-Box
-
SKU: SHU-00041
Model: SM48-LC
Condition: New-In-Box
-
SKU: SHU-00510
Model: A95U
Condition: New-In-Box
-
SKU: SHU-00263
Model: AMV88
Condition: New-In-Box
-
SKU: SHU-00512
Model: FP3
Condition: New-In-Box
-
SKU: SHU-00513
Model: FP5
Condition: New-In-Box
-
SKU: SHU-00514
Model: A89MW-SFT
Condition: New-In-Box
-
SKU: SHU-00415
Model: SE215SPE-B-BT1
Condition: New-In-Box
-
SKU: SHU-00550
Model: BLX14/CVL-H10
Condition: New-In-Box