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 (5032, 5035, 5048, 5111, 5133, 5154, 393965, 463936, 474859, 479504, 479534, 481132, 331516, 331517, 338128, 344784, 344785, 344787, 403574, 408361, 408365, 408367, 408372, 408379, 408380, 408385, 408387, 411425, 413913, 486137)) 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,5032,5035,5048,5111,5133,5154,393965,463936,474859,479504,479534,481132,331516,331517,338128,344784,344785,344787,403574,408361,408365,408367,408372,408379,408380,408385,408387,411425,413913,486137)
-
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-MANPROCUBE
Model: MANPROCUBEC, MANPROCUBEN, MANPROCUBES
Condition: New-In-Box
-
SKU: MAN-12003A
Model: MKELES5CF-BH
Condition: New-In-Box
-
SKU: MAN-ELEMENTTRAVSM
Model: MKELES5RD-BH, MKELES5BK-BH
Condition: New-In-Box
-
SKU: MAN-ADVSHLDRIII
Model: MB MA3-SB-L, MB MA3-SB-M, MB MA3-SB-S, MB MA3-SB-XS
Condition: New-In-Box
-
SKU: MAN-ADVHOLSIII
Model: MB MA3-H-L, MB MA3-H-M, MB MA3-H-S
Condition: New-In-Box
-
SKU: MAN-PLBACKLOADER
Model: MB PL2-BP-BL-S, MB PL2-BP-BL-M
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-MH496-Q6
Model: MH496-Q6
Condition: New-In-Box