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 (2716, 2732, 2738, 2744, 2746, 2775, 2779, 2795, 393965, 331516, 331517, 338128, 344784, 344785, 344787, 403574, 408361, 408365, 408367, 408372, 408379, 408380, 408385, 408387, 411425, 413913, 288697, 288702, 212080, 215870)) 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,2716,2732,2738,2744,2746,2775,2779,2795,393965,331516,331517,338128,344784,344785,344787,403574,408361,408365,408367,408372,408379,408380,408385,408387,411425,413913,288697,288702,212080,215870)
-
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-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
-
SKU: MAN-12006
Model: MKELMII4BMB-BH
Condition: New-In-Box
-
SKU: MAN-12008
Model: MKELMII4CMB-BH
Condition: New-In-Box
-
SKU: MAN-00349A
Model: 200LT-PL-PRO
Condition: New-In-Box
-
SKU: MAN-12020
Model: MVMELMIIA4
Condition: New-In-Box
-
SKU: MAN-04001
Model: MB MA3-BP-BF
Condition: New-In-Box
-
SKU: MAN-04005
Model: MB MA3-BP-H
Condition: New-In-Box
-
SKU: MAN-04006
Model: MB MA3-BP-T
Condition: New-In-Box
-
SKU: MAN-04010
Model: MB MA3-M-M
Condition: New-In-Box
-
SKU: MAN-04017
Model:
Condition: New-In-Box
-
SKU: MAN-04016
Model: MB MS2-BP
Condition: New-In-Box
-
SKU: MAN-04022
Model: MB PL2-BP-FL-M
Condition: New-In-Box
-
SKU: MAN-04024
Model: MB PL2-BP-ML-M
Condition: New-In-Box
-
Sizes: 7', 8', 9', 12'
SKU: 25225
Model: 1004BAC-3, 1005BAC-3, 1052BAC-3, 1051BAC-3
Condition: New-In-Box
-
SKU: MAN-00060B
Model: 032B
Condition: New-In-Box
-
SKU: MAN-02282A
Model: MB MA2-BP-GM
Condition: New-In-Box
-
SKU: MAN-02298
Model: MB MN-R-RN-50
Condition: New-In-Box
-
SKU: MAN-02463A
Model: MVKBFRL-LIVEUS
Condition: New-In-Box
-
SKU: MAN-02799V
Model: MVK500190XV
Condition: New-In-Box