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 (608435, 608434, 601388, 601382, 584931, 574460, 544709, 370562, 379253, 379259, 379263, 379269, 379272, 449474, 475156, 334525, 337829, 361665, 369791, 420746, 420750, 488793, 518649, 518680, 518707, 518719, 518721, 518742, 518743, 518744)) 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,608435,608434,601388,601382,584931,574460,544709,370562,379253,379259,379263,379269,379272,449474,475156,334525,337829,361665,369791,420746,420750,488793,518649,518680,518707,518719,518721,518742,518743,518744)
-
SKU: SAR-00502
Model: BOOMPOLELITE
Condition: New-In-Box
-
SKU: SAR-00061
Model: BLINK500B2+
Condition: New-In-Box
-
SKU: SAR-00076
Model: BLINK500PROXTXR
Condition: New-In-Box
-
SKU: SAR-00075
Model: BLINK500PROX2R
Condition: New-In-Box
-
SKU: SAR-00069
Model: BLINK500PROXHM
Condition: New-In-Box
-
SKU: SAR-01027
Model: WITALK-WT5S
Condition: New-In-Box
-
SKU: SAR-BLINKMEB2
Model: BLINKMEB2
Condition: New-In-Box
-
SKU: SAR-00336
Model: SR-VM4
Condition: New-In-Box
-
SKU: SAR-00447
Model: UWMIC9S-KIT1
Condition: New-In-Box
-
SKU: SAR-00449
Model: SOUNDBIRDT3L
Condition: New-In-Box
-
SKU: SAR-00457
Model: SMARTMIC5
Condition: New-In-Box
-
SKU: SAR-00459
Model: SMARTMIC5S
Condition: New-In-Box
-
SKU: SAR-00460
Model: SMARTMIC5UC
Condition: New-In-Box
-
SKU: SAR-00062
Model: BLINK900B2
Condition: New-In-Box
-
SKU: SAR-SR-MC1
Model: SR-MC1
Condition: New-In-Box
-
SKU: SAR-00055A
Model: BLINK 500 B5
Condition: New-In-Box
-
SKU: SAR-CXLR
Model: C-XLR
Condition: New-In-Box
-
SKU: SAR-00335WS
Model: VMICMINI-WS
Condition: New-In-Box
-
SKU: SAR-00184
Model: SR-C2002
Condition: New-In-Box
-
SKU: SAR-00331
Model: VMIC5
Condition: New-In-Box
-
SKU: SAR-00332
Model: VMIC5PRO
Condition: New-In-Box
-
SKU: SAR-00071
Model: BLINK500PROXB2
Condition: New-In-Box
-
SKU: SAR-01013
Model: AX1
Condition: New-In-Box
-
SKU: SAR-01016
Model: BLINK100B3
Condition: New-In-Box
-
SKU: SAR-01018
Model: BLINK100B5
Condition: New-In-Box
-
SKU: SAR-01019
Model: BLINK100B6
Condition: New-In-Box
-
SKU: SAR-01020
Model: BLINK500PROXB3
Condition: New-In-Box
-
SKU: SAR-01023
Model: BLINK500PROXB6
Condition: New-In-Box
-
SKU: SAR-01024
Model: SR-EA2D
Condition: New-In-Box
-
SKU: SAR-01025
Model: SR-EA2U
Condition: New-In-Box