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 (618723, 614003, 608399, 608398, 608397, 608396, 608395, 608394, 593048, 593030, 593026, 593025, 592946, 574844, 552566, 552565, 552563, 552552, 257607, 257793, 265175, 265176, 265177, 265285, 265286, 265287, 265288, 265289, 265324, 265325)) 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,618723,614003,608399,608398,608397,608396,608395,608394,593048,593030,593026,593025,592946,574844,552566,552565,552563,552552,257607,257793,265175,265176,265177,265285,265286,265287,265288,265289,265324,265325)
-
SKU: BNR-QRB95
Model: QRB95
Condition: New-In-Box
-
SKU: BNR-00135
Model: GPAC502
Condition: New-In-Box
-
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-QR15C
Model: QR15C
Condition: New-In-Box
-
SKU: BNR-KH26PC
Model: KH26PC
Condition: New-In-Box
-
SKU: BNR-KH25PC
Model: KH25PC
Condition: New-In-Box
-
SKU: BNR-BS03
Model: BS03
Condition: New-In-Box
-
SKU: BNR-PU45C
Model: PU45C
Condition: New-In-Box
-
SKU: BNR-TSSL08AN00P
Model: TSSL08AN00P
Condition: New-In-Box
-
SKU: BNR-MSD46C72
Model: MSD46C72
Condition: New-In-Box
-
SKU: BNR-TSSL08CN00P
Model: TSSL08CN00P
Condition: New-In-Box
-
SKU: BNR-BV4H
Model: BV4H
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-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