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 (2775, 331517, 344784, 198415, 212080, 215870, 143876, 183015, 183358, 68186, 68194, 18323, 16022, 17487, 17492, 37068, 82287, 82288, 100257, 107044, 107045, 107046, 403574, 474859, 2718, 2730, 2784, 2789, 2799, 5118)) 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,2775,331517,344784,198415,212080,215870,143876,183015,183358,68186,68194,18323,16022,17487,17492,37068,82287,82288,100257,107044,107045,107046,403574,474859,2718,2730,2784,2789,2799,5118)
-
SKU: MAN-00660
Model: 475B
Condition: New-In-Box
-
SKU: MAN-024636
Model: MKBFRLA4BK-3WUS
Condition: New-In-Box
-
SKU: MAN-12006
Model: MKELMII4BMB-BH
Condition: New-In-Box
-
SKU: MAN-01025
Model: MVMXPROA4577
Condition: New-In-Box
-
SKU: MAN-02463A
Model: MVKBFRL-LIVEUS
Condition: New-In-Box
-
SKU: MAN-02799V
Model: MVK500190XV
Condition: New-In-Box
-
SKU: MAN-027231A
Model: MT190GOA4US
Condition: New-In-Box
-
SKU: MAN-024634
Model: MVKBFRT-LIVEUS
Condition: New-In-Box
-
SKU: MAN-0246134
Model: MKBFRTA4GT-BHUS
Condition: New-In-Box
-
SKU: MAN-02423D
Model: MK190XPRO3-BHQ2
Condition: New-In-Box
-
SKU: MAN-02423E
Model: MK190XPRO4-BHQ2
Condition: New-In-Box
-
SKU: MAN-02423C
Model: MK190X3-2W
Condition: New-In-Box
-
SKU: MAN-02799
Model: MVK500AM
Condition: New-In-Box
-
SKU: MAN-02718
Model: MT190XPRO3
Condition: New-In-Box
-
SKU: MAN-02426C
Model: MK190XPRO4-3W
Condition: New-In-Box
-
SKU: MAN-02741
Model: MK290DUA3-3WUS
Condition: New-In-Box
-
SKU: MAN-02811
Model: MVMXPRO500US
Condition: New-In-Box
-
SKU: MAN-02812
Model: MVMXPROA42WUS
Condition: New-In-Box
-
SKU: MAN-02813
Model: MVMXPROA4US
Condition: New-In-Box
-
SKU: MAN-02745
Model: MT290XTA3US
Condition: New-In-Box
-
SKU: MAN-02746
Model: MK290XTA3-2WUS
Condition: New-In-Box
-
SKU: MAN-02747
Model: MK290XTA3-3WUS
Condition: New-In-Box
-
SKU: MAN-12020
Model: MVMELMIIA4
Condition: New-In-Box
-
SKU: MAN-ELEMENTTRAVSM
Model: MKELES5RD-BH, MKELES5BK-BH
Condition: New-In-Box
-
SKU: MAN-00286
Model: 161MK2B (3058, 3258)
Condition: New-In-Box
-
SKU: MAN-00364
Model: 209 (3007)
Condition: New-In-Box
-
SKU: MAN-00779
Model: 526,545GBK
Condition: New-In-Box
-
SKU: MAN-00808
Model: 558B
Condition: New-In-Box
-
SKU: MAN-00988
Model: 755XB
Condition: New-In-Box
-
SKU: MAN-00636
Model: 458B
Condition: New-In-Box