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 (61904, 62154, 62865, 62872, 62873, 20800, 20801, 20802, 20803, 14761, 14762, 14763, 14765, 14766, 14767, 14769, 88889, 88890, 88891, 98688, 98689, 123316, 123317, 123318, 123319, 123320, 124245, 124246, 124247, 124248)) 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,61904,62154,62865,62872,62873,20800,20801,20802,20803,14761,14762,14763,14765,14766,14767,14769,88889,88890,88891,98688,98689,123316,123317,123318,123319,123320,124245,124246,124247,124248)
-
SKU: NIS-00440
Model: NDMF18C
Condition: New-In-Box
-
SKU: NIS-00441
Model: NDMF18N
Condition: New-In-Box
-
SKU: NIS-00425
Model: ND700a-S
Condition: New-In-Box
-
SKU: NIS-00512
Model: ND700AK-N
Condition: New-In-Box
-
SKU: NIS-00515
Model: ND700AK-S
Condition: New-In-Box
-
SKU: NIS-00430
Model: ND40-C
Condition: New-In-Box
-
SKU: NIS-00432
Model: ND40-N
Condition: New-In-Box
-
SKU: NIS-00434
Model: ND40-S
Condition: New-In-Box
-
SKU: NIS-00436
Model: ND40-FJ
Condition: New-In-Box
-
SKU: NIS-00210
Model: ND866MKII-C
Condition: New-In-Box
-
SKU: NIS-00220
Model: ND866MKII-N
Condition: New-In-Box
-
SKU: NIS-00230
Model: ND866MKII-S
Condition: New-In-Box
-
SKU: NIS-00310
Model: ND622MKII-C
Condition: New-In-Box
-
SKU: NIS-00320
Model: ND622MKII-N
Condition: New-In-Box
-
SKU: NIS-00330
Model: ND622MKII-S
Condition: New-In-Box
-
SKU: NIS-00610
Model: NDSC01
Condition: New-In-Box
-
SKU: NIS-00700
Model: NDAR-C
Condition: New-In-Box
-
SKU: NIS-00701
Model: NDAR-N
Condition: New-In-Box
-
SKU: NIS-00702
Model: NDAR-S
Condition: New-In-Box
-
SKU: NIS-00426
Model: ND700A-FJ
Condition: New-In-Box
-
SKU: NIS-00516
Model: ND700AK-FJ
Condition: New-In-Box
-
SKU: NIS-00520
Model: MDA10-C
Condition: New-In-Box
-
SKU: NIS-00521
Model: MDA10-F
Condition: New-In-Box
-
SKU: NIS-00522
Model: MDA10-FT
Condition: New-In-Box
-
SKU: NIS-00523
Model: MDA10-N
Condition: New-In-Box
-
SKU: NIS-00524
Model: MDA10-S
Condition: New-In-Box
-
SKU: NIS-00438
Model: ND40-FT
Condition: New-In-Box
-
SKU: NIS-00450
Model: ND60A-C
Condition: New-In-Box
-
SKU: NIS-00452
Model: ND60A-N
Condition: New-In-Box
-
SKU: NIS-00454
Model: ND60A-S
Condition: New-In-Box