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 (12817, 12818, 12820, 12821, 12822, 12823, 12825, 12826, 13354, 7257, 7441, 8852, 8853, 12271, 3858, 3859, 3861, 3862, 3863, 3864, 3865, 3869, 3870, 3873, 3874, 3875, 3878, 3881, 3882, 3883)) 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,12817,12818,12820,12821,12822,12823,12825,12826,13354,7257,7441,8852,8853,12271,3858,3859,3861,3862,3863,3864,3865,3869,3870,3873,3874,3875,3878,3881,3882,3883)
-
SKU: QUA-00370
Model: FW29
Condition: New-In-Box
-
SKU: QUA-00367
Model: FW89
Condition: New-In-Box
-
SKU: QUA-00357
Model: FW44
Condition: New-In-Box
-
SKU: QUA-00345
Model: FW31
Condition: New-In-Box
-
SKU: QUA-00341
Model: FW22
Condition: New-In-Box
-
SKU: QUA-00340
Model: FW21
Condition: New-In-Box
-
SKU: QUA-00325A
Model: FW10W
Condition: New-In-Box
-
SKU: QUA-00322F
Model: FW9T
Condition: New-In-Box
-
SKU: QUA-00212
Model: QF36X
Condition: New-In-Box
-
SKU: QUA-00299E
Model: TCRU
Condition: New-In-Box
-
SKU: QUA-00299G
Model: TSC
Condition: New-In-Box
-
SKU: QUA-00249G
Model: QF75
Condition: New-In-Box
-
SKU: QUA-00249K
Model: QF76
Condition: New-In-Box
-
SKU: QUA-00176V
Model: QF26
Condition: New-In-Box
-
SKU: QUA-00001
Model: 415
Condition: New-In-Box
-
SKU: QUA-00003
Model: 434
Condition: New-In-Box
-
SKU: QUA-00024
Model: 465
Condition: New-In-Box
-
SKU: QUA-00039
Model: 515
Condition: New-In-Box
-
SKU: QUA-00045
Model: 536
Condition: New-In-Box
-
SKU: QUA-00066
Model: CD30
Condition: New-In-Box
-
SKU: QUA-00070G
Model: CCQ8
Condition: New-In-Box
-
SKU: QUA-00089
Model: CV Cable
Condition: New-In-Box
-
SKU: QUA-00097T
Model: MB2
Condition: New-In-Box
-
SKU: QUA-00176S
Model: QF9N
Condition: New-In-Box
-
SKU: QUA-00251J
Model: qf80
Condition: New-In-Box
-
SKU: QUA-00258E
Model: QFT5D-R
Condition: New-In-Box
-
SKU: QUA-00271
Model: QPR1US
Condition: New-In-Box
-
SKU: QUA-00296
Model: TBLUS
Condition: New-In-Box
-
SKU: QUA-00299AA
Model: T3 Battery Pack
Condition: New-In-Box
-
SKU: QUA-00313C
Model: XKZ9
Condition: New-In-Box