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 (330812, 353659, 367202, 369775, 369776, 404807, 420062, 420064, 420112, 436364, 257607, 257793, 265175, 265176, 265177, 265285, 265286, 265287, 265288, 265289, 265324, 265325, 265326, 265327, 265339, 266628, 320155, 320156, 320157, 320159)) 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,330812,353659,367202,369775,369776,404807,420062,420064,420112,436364,257607,257793,265175,265176,265177,265285,265286,265287,265288,265289,265324,265325,265326,265327,265339,266628,320155,320156,320157,320159)
-
SKU: BNR-S2PRO
Model: S2PRO
Condition: New-In-Box
-
SKU: BNR-00140
Model: KH26P
Condition: New-In-Box
-
SKU: BNR-KH25P
Model: KH25P
Condition: New-In-Box
-
SKU: BNR-101602
Model: MSD46C
Condition: New-In-Box
-
SKU: BNR-101604
Model: MSDPL46C
Condition: New-In-Box
-
SKU: BNR-100803
Model: BK15
Condition: New-In-Box
-
SKU: BNR-FSL09AN00
Model: FSL09AN00
Condition: New-In-Box
-
SKU: BNR-FSL09CN00
Model: FSL09CN00
Condition: New-In-Box
-
SKU: BNR-BINOH200
Model: BINOH200
Condition: New-In-Box
-
SKU: BNR-100302
Model: TPKFL
Condition: New-In-Box
-
SKU: BNR-00001
Model: 3XS
Condition: New-In-Box
-
SKU: BNR-HD2A
Model: HD2A
Condition: New-In-Box
-
SKU: BNR-S4PRO
Model: S4PRO
Condition: New-In-Box
-
SKU: BNR-S6PRO
Model: S6PRO
Condition: New-In-Box
-
SKU: BNR-S8PRO
Model: S8PRO
Condition: New-In-Box
-
SKU: BNR-A2573FS4PRO
Model: A2573FS4PRO
Condition: New-In-Box
-
SKU: BNR-A2573FS6PRO
Model: A2573FS6PRO
Condition: New-In-Box
-
SKU: BNR-A373FBS6PRO
Model: A373FBS6PRO
Condition: New-In-Box
-
SKU: BNR-A373FBS8PRO
Model: A373FBS8PRO
Condition: New-In-Box
-
SKU: BNR-C373FBS8PRO
Model: C373FBS8PRO
Condition: New-In-Box
-
SKU: BNR-A48FDS4PRO
Model: A48FDS4PRO
Condition: New-In-Box
-
SKU: BNR-A48FDS6PRO
Model: A48FDS6PRO
Condition: New-In-Box
-
SKU: BNR-QR4PRO
Model: QR4PRO
Condition: New-In-Box
-
SKU: BNR-QR6PRO
Model: QR6PRO
Condition: New-In-Box
-
SKU: BNR-QR8PRO
Model: QR8PRO
Condition: New-In-Box
-
SKU: BNR-LBA2
Model: LBA2
Condition: New-In-Box
-
SKU: BNR-FBAT15AVX20
Model: FBAT15AVX20
Condition: New-In-Box
-
SKU: BNR-FBAT15CVX20
Model: FBAT15CVX20
Condition: New-In-Box
-
SKU: BNR-FRHN24CVX25
Model: FRHN24CVX25
Condition: New-In-Box
-
SKU: BNR-GX30
Model: GX30
Condition: New-In-Box