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, 344785, 143878, 150462, 183006, 183007, 183008, 17451, 463936, 5130, 2785, 8239, 8241, 8242, 8303, 373987, 239411, 240722, 244992, 244994, 257258, 315830, 315832, 315834, 315836, 315838, 315989, 316020, 316021)) 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,344785,143878,150462,183006,183007,183008,17451,463936,5130,2785,8239,8241,8242,8303,373987,239411,240722,244992,244994,257258,315830,315832,315834,315836,315838,315989,316020,316021)
-
SKU: MAN-00141
Model: MK055CXPRO4BHQR
Condition: New-In-Box
-
SKU: MAN-02421
Model: MK055CXPRO33WQR
Condition: New-In-Box
-
SKU: MAN-12008
Model: MKELMII4CMB-BH
Condition: New-In-Box
-
SKU: MAN-027231C
Model: MT190GOC4US
Condition: New-In-Box
-
SKU: MAN-02532B
Model: MPMXPROC4US
Condition: New-In-Box
-
SKU: MAN-024631
Model: MKBFRTC4-BHUS
Condition: New-In-Box
-
SKU: MAN-024632
Model: MKBFRTC4GT-BHUS
Condition: New-In-Box
-
SKU: MAN-024633
Model: MVKBFRTC-LIVEUS
Condition: New-In-Box
-
SKU: MAN-00745
Model: 504HD,536K
Condition: New-In-Box
-
SKU: MAN-12003A
Model: MKELES5CF-BH
Condition: New-In-Box
-
SKU: MAN-00788
Model: 536
Condition: New-In-Box
-
SKU: MAN-00786
Model: 535
Condition: New-In-Box
-
SKU: MAN-02710
Model: MT057C3
Condition: New-In-Box
-
SKU: MAN-02712
Model: MT057C3-G
Condition: New-In-Box
-
SKU: MAN-02714
Model: MT057C4
Condition: New-In-Box
-
SKU: MAN-02716
Model: MT057C4-G
Condition: New-In-Box
-
SKU: MAN-028097
Model: 3964
Condition: New-In-Box
-
SKU: MAN-02807
Model: MVK502C-1
Condition: New-In-Box
-
SKU: MAN-024635
Model: MKBFRTC4GTA-BUS
Condition: New-In-Box
-
SKU: MAN-007781
Model: 526,536K-1
Condition: New-In-Box
-
SKU: MAN-02461GC
Model: MKBFRC4GTXP-BUS
Condition: New-In-Box
-
SKU: MAN-02809
Model: MVK608TWINGCUS
Condition: New-In-Box
-
SKU: MAN-00727
Model: MVTTWINFCUS
Condition: New-In-Box
-
SKU: MAN-028096C
Model: MVK608TWINFC
Condition: New-In-Box
-
SKU: MAN-028097C
Model: MVK612TWINFC
Condition: New-In-Box
-
SKU: MAN-028098C
Model: MVK509TWINFC
Condition: New-In-Box
-
SKU: MAN-028099C
Model: MVK526TWINFC
Condition: New-In-Box
-
SKU: MAN-00729
Model: MVTSNGFC
Condition: New-In-Box
-
SKU: MAN-028100
Model: MVK608SNGFC
Condition: New-In-Box
-
SKU: MAN-028101
Model: MVK612SNGFCUS
Condition: New-In-Box