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 (591785, 591778, 566124, 4868, 4873, 5030, 5031, 5032, 5035, 5048, 5111, 5133, 5154, 2680, 2694, 2708, 2716, 2732, 2738, 2744, 2746, 2775, 2779, 2795, 12671, 12704, 12709, 12710, 12711, 12715)) 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,591785,591778,566124,4868,4873,5030,5031,5032,5035,5048,5111,5133,5154,2680,2694,2708,2716,2732,2738,2744,2746,2775,2779,2795,12671,12704,12709,12710,12711,12715)
-
SKU: MAN-00141
Model: MK055CXPRO4BHQR
Condition: New-In-Box
-
SKU: MAN-02421
Model: MK055CXPRO33WQR
Condition: New-In-Box
-
SKU: MAN-MVAQR
Model: MVAQR
Condition: New-In-Box
-
SKU: MAN-00048
Model: 026
Condition: New-In-Box
-
SKU: MAN-00086
Model: 035RL
Condition: New-In-Box
-
SKU: MAN-00410
Model: 243 (3292)
Condition: New-In-Box
-
SKU: MAN-00416
Model: 244N
Condition: New-In-Box
-
SKU: MAN-00418
Model: 244RC (2929QR)
Condition: New-In-Box
-
SKU: MAN-00504
Model: 322RC2
Condition: New-In-Box
-
SKU: MAN-00578
Model: 394
Condition: New-In-Box
-
SKU: MAN-00596
Model: 410PL (3271)
Condition: New-In-Box
-
SKU: MAN-00820
Model: 577
Condition: New-In-Box
-
SKU: MAN-02025
Model: AW 3281BLK
Condition: New-In-Box
-
SKU: MAN-00027
Model: 013 SPIGOT ADAPTER
Condition: New-In-Box
-
SKU: MAN-00106
Model: 045
Condition: New-In-Box
-
SKU: MAN-00214
Model: 119 (3108)
Condition: New-In-Box
-
SKU: MAN-00266
Model: 148KN (148,148K,3111)
Condition: New-In-Box
-
SKU: MAN-00414
Model: 244 (2929)
Condition: New-In-Box
-
SKU: MAN-00508
Model: 323 (3299)
Condition: New-In-Box
-
SKU: MAN-00582
Model: 396B-2
Condition: New-In-Box
-
SKU: MAN-00594
Model: 410 (3275)
Condition: New-In-Box
-
SKU: MAN-00660
Model: 475B
Condition: New-In-Box
-
SKU: MAN-00720
Model: 501PL (3433PL)
Condition: New-In-Box
-
SKU: MAN-00872
Model: 635
Condition: New-In-Box
-
SKU: MAN-00094
Model: 037 (2907)
Condition: New-In-Box
-
SKU: MAN-01096
Model: 1004BAC
Condition: New-In-Box
-
SKU: MAN-01094
Model: 1005BAC
Condition: New-In-Box
-
SKU: MAN-01092
Model: 1052BAC
Condition: New-In-Box
-
SKU: MAN-01090
Model: 1051BAC
Condition: New-In-Box
-
SKU: MAN-00392
Model: 231CS
Condition: New-In-Box