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 (608399, 608398, 608397, 593025, 592946, 552566, 552565, 552563, 552552, 370982, 369775, 369776, 420064, 436364, 265289, 320156, 320157, 320161, 320162, 156079, 156086, 156093, 65985, 15683, 15687, 114459, 449429, 477179, 370995, 371710)) 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,608399,608398,608397,593025,592946,552566,552565,552563,552552,370982,369775,369776,420064,436364,265289,320156,320157,320161,320162,156079,156086,156093,65985,15683,15687,114459,449429,477179,370995,371710)
-
SKU: BNR-TMTH43C
Model: TMTH43C
Condition: New-In-Box
-
SKU: BNR-TMTH34C
Model: TMTH34C
Condition: New-In-Box
-
SKU: BNR-TMTH33C
Model: TMTH33C
Condition: New-In-Box
-
SKU: BNR-MSD46C72
Model: MSD46C72
Condition: New-In-Box
-
SKU: BNR-TSSL08CN00P
Model: TSSL08CN00P
Condition: New-In-Box
-
SKU: BNR-TTOR34CLV
Model: TTOR34CLV
Condition: New-In-Box
-
SKU: BNR-TTOR24CLV
Model: TTOR24CLV
Condition: New-In-Box
-
SKU: BNR-FRHN24C
Model: FRHN24C
Condition: New-In-Box
-
SKU: BNR-FRHN14C
Model: FRHN14C
Condition: New-In-Box
-
SKU: BNR-FRHN05CVX20
Model: FRHN05CVX20
Condition: New-In-Box
-
SKU: BNR-101602
Model: MSD46C
Condition: New-In-Box
-
SKU: BNR-101604
Model: MSDPL46C
Condition: New-In-Box
-
SKU: BNR-FSL09CN00
Model: FSL09CN00
Condition: New-In-Box
-
SKU: BNR-100302
Model: TPKFL
Condition: New-In-Box
-
SKU: BNR-C373FBS8PRO
Model: C373FBS8PRO
Condition: New-In-Box
-
SKU: BNR-FBAT15CVX20
Model: FBAT15CVX20
Condition: New-In-Box
-
SKU: BNR-FRHN24CVX25
Model: FRHN24CVX25
Condition: New-In-Box
-
SKU: BNR-TTOR03CGX25
Model: TTOR03CGX25
Condition: New-In-Box
-
SKU: BNR-TTOR24CGX30
Model: TTOR24CGX30
Condition: New-In-Box
-
SKU: BNR-MAD49C
Model: MAD49C
Condition: New-In-Box
-
SKU: BNR-TAD28CB2
Model: TAD28CB2
Condition: New-In-Box
-
SKU: BNR-TMA38CL
Model: TMA38CL
Condition: New-In-Box
-
SKU: BNR-MAD38C
Model: MAD38C
Condition: New-In-Box
-
SKU: BNR-101062T
Model: C2350Q2T
Condition: New-In-Box
-
SKU: BNR-101060T
Model: C1350Q1T
Condition: New-In-Box
-
SKU: BNR-TSL08CN00
Model: TSL08CN00
Condition: New-In-Box
-
SKU: BNR-FBAT05CVX20
Model: FBAT05CVX20
Condition: New-In-Box
-
SKU: BNR-BVX18CFKPRO
Model: BVX18CFKPRO
Condition: New-In-Box
-
SKU: BNR-TTOR14CGX25
Model: TTOR14CGX25
Condition: New-In-Box
-
SKU: BNR-101100
Model: C373FBV6H
Condition: New-In-Box