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, 12253, 12335, 5030, 5031, 5032, 5035, 5048, 5111, 5133, 5154, 2680, 2694, 2708, 2716, 2732, 2738, 2744, 2746, 2775, 2779, 2795, 4868, 4873, 393965, 331516, 331517, 338128)) 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,12253,12335,5030,5031,5032,5035,5048,5111,5133,5154,2680,2694,2708,2716,2732,2738,2744,2746,2775,2779,2795,4868,4873,393965,331516,331517,338128)
-
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-02798
Model: MVH502AH
Condition: New-In-Box
-
SKU: MAN-00080
Model: 035
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-00048
Model: 026
Condition: New-In-Box
-
SKU: MAN-00086
Model: 035RL
Condition: New-In-Box
-
SKU: MAN-MANPROCUBE
Model: MANPROCUBEC, MANPROCUBEN, MANPROCUBES
Condition: New-In-Box
-
SKU: MAN-02384
Model: MH01HY-3WUS
Condition: New-In-Box
-
SKU: MAN-024636
Model: MKBFRLA4BK-3WUS
Condition: New-In-Box
-
SKU: MAN-02570
Model: 1556
Condition: New-In-Box