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 (16489, 17392, 15573, 15574, 15608, 15609, 15610, 15611, 15612, 15613, 15614, 8779, 8780, 8781, 8783, 8784, 8785, 8786, 8787, 8788, 9806, 900, 901, 902, 905, 907, 908, 909, 919, 920)) 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,16489,17392,15573,15574,15608,15609,15610,15611,15612,15613,15614,8779,8780,8781,8783,8784,8785,8786,8787,8788,9806,900,901,902,905,907,908,909,919,920)
-
SKU: CUS-02722
Model: QRA-C KIT
Condition: New-In-Box
-
SKU: CUS-02842
Model: SP-350
Condition: New-In-Box
-
SKU: CUS-02780
Model: RF-PRO
Condition: New-In-Box
-
SKU: CUS-02782
Model: RF-C1
Condition: New-In-Box
-
SKU: CUS-02784
Model: RF-C2
Condition: New-In-Box
-
SKU: CUS-02786
Model: RF-CB
Condition: New-In-Box
-
SKU: CUS-01452
Model: CB FOLDING-TA
Condition: New-In-Box
-
SKU: CUS-01442
Model: CB FOLDING-SA
Condition: New-In-Box
-
SKU: CUS-01444
Model: CB FOLDING-SAB
Condition: New-In-Box
-
SKU: CUS-01446
Model: CB FOLDING-SB
Condition: New-In-Box
-
SKU: CUS-01424
Model: CB DIGITAL-SB
Condition: New-In-Box
-
SKU: CUS-01070
Model: ATP
Condition: New-In-Box
-
SKU: CUS-01310
Model: CAB 9
Condition: New-In-Box
-
SKU: CUS-01315
Model: CAB 14
Condition: New-In-Box
-
SKU: CUS-02320
Model: GFT
Condition: New-In-Box
-
SKU: CUS-02342
Model: GLM 8.5
Condition: New-In-Box
-
SKU: CUS-02390
Model: HDV PRO KIT
Condition: New-In-Box
-
SKU: CUS-02960
Model: TFM
Condition: New-In-Box
-
SKU: CUS-03010
Model: TILT HEAD AS
Condition: New-In-Box
-
SKU: CUS-03020
Model: TILT HEAD CB
Condition: New-In-Box
-
SKU: CUS-02720
Model: QR-C Kit
Condition: New-In-Box
-
SKU: CUS-01430
Model: CB Digital-T
Condition: New-In-Box
-
SKU: CUS-01685
Model: CB JUNIOR KIT
Condition: New-In-Box
-
SKU: CUS-01695
Model: CB MINI-RC
Condition: New-In-Box
-
SKU: CUS-01870
Model: CN-JR
Condition: New-In-Box
-
SKU: CUS-01920
Model: PRO-E
Condition: New-In-Box
-
SKU: CUS-01930
Model: DIGITAL PRO M
Condition: New-In-Box
-
SKU: CUS-01950
Model: Digital PRO SV
Condition: New-In-Box
-
SKU: CUS-02450
Model: MC Cold Shoe
Condition: New-In-Box
-
SKU: CUS-02710
Model: QR-C
Condition: New-In-Box