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 (566124, 46296, 68186, 68194, 18323, 16022, 16023, 16500, 17079, 17451, 17482, 17487, 17492, 17528, 37068, 82148, 82287, 82288, 100257, 107044, 107045, 107046, 116552, 116553, 141033, 141038, 143876, 143878, 150462, 183006)) 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,566124,46296,68186,68194,18323,16022,16023,16500,17079,17451,17482,17487,17492,17528,37068,82148,82287,82288,100257,107044,107045,107046,116552,116553,141033,141038,143876,143878,150462,183006)
-
SKU: MAN-MVAQR
Model: MVAQR
Condition: New-In-Box
-
SKU: MAN-02383
Model: MHXPRO-BHQ6
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-02791
Model: MVH500AH
Condition: New-In-Box
-
SKU: MAN-02626
Model: MSQ6PL
Condition: New-In-Box
-
SKU: MAN-00117
Model: 046MCB
Condition: New-In-Box
-
SKU: MAN-00745
Model: 504HD,536K
Condition: New-In-Box
-
SKU: MAN-02380
Model: MHXPRO-3W
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-02702
Model: MT055XPRO3
Condition: New-In-Box
-
SKU: MAN-02741
Model: MK290DUA3-3WUS
Condition: New-In-Box
-
SKU: MAN-02777
Model: MCLAMP
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-10762A
Model: MB PL-B-130
Condition: New-In-Box
-
SKU: MAN-10765
Model: MB PL-BM-30
Condition: New-In-Box
-
SKU: MAN-00701
Model: 500PLONG
Condition: New-In-Box
-
SKU: MAN-02360
Model: MH804-3WUS
Condition: New-In-Box
-
SKU: MAN-027231A
Model: MT190GOA4US
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