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 (408385, 408387, 411425, 413913, 486137, 254603, 288697, 288702, 198415, 201291, 201390, 212080, 212179, 215870, 228194, 42977, 46296, 52324, 61897, 61898, 65283, 68179, 69454, 71060, 75829, 17699, 17713, 17714, 17715, 17716)) 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,408385,408387,411425,413913,486137,254603,288697,288702,198415,201291,201390,212080,212179,215870,228194,42977,46296,52324,61897,61898,65283,68179,69454,71060,75829,17699,17713,17714,17715,17716)
-
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
-
SKU: MAN-10955
Model: MB PL-LW-99-2
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-01025
Model: MVMXPROA4577
Condition: New-In-Box
-
SKU: MAN-02799X
Model: MVK500190X3
Condition: New-In-Box
-
SKU: MAN-00748
Model: 504PLONG
Condition: New-In-Box
-
SKU: MAN-02463A
Model: MVKBFRL-LIVEUS
Condition: New-In-Box
-
SKU: MAN-02462
Model: MVH400AHUS
Condition: New-In-Box
-
SKU: MAN-02799V
Model: MVK500190XV
Condition: New-In-Box
-
SKU: MAN-02815
Model: MVMXPROC5US
Condition: New-In-Box
-
SKU: MAN-10754
Model: MB PL-AH-16
Condition: New-In-Box
-
SKU: MAN-02383
Model: MHXPRO-BHQ6
Condition: New-In-Box
-
SKU: MAN-02531
Model: MMXPROA4US
Condition: New-In-Box
-
SKU: MAN-01187
Model: ROUND-PL
Condition: New-In-Box
-
SKU: MAN-02777A
Model: MSCLAMP
Condition: New-In-Box
-
SKU: MAN-02423GOKIT
Model: MK190GOA4B-BHUS
Condition: New-In-Box
-
SKU: MAN-02419Q
Model: MK055XPRO3-BHQ2
Condition: New-In-Box
-
SKU: MAN-00744K
Model: 504HD,535K
Condition: New-In-Box
-
SKU: MAN-02499A
Model: MLUMIEPL-BK
Condition: New-In-Box
-
SKU: MAN-02870
Model: MVS060A
Condition: New-In-Box
-
SKU: MAN-10756
Model: MB PL-AH-18
Condition: New-In-Box
-
SKU: MAN-10780
Model: MB PL-E-690
Condition: New-In-Box
-
SKU: MAN-10782
Model: MB PL-E-702
Condition: New-In-Box
-
SKU: MAN-10784
Model: MB PL-E-704
Condition: New-In-Box
-
SKU: MAN-10786
Model: MB PL-E-705
Condition: New-In-Box