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 (533717, 533732, 369969, 370995, 371710, 379251, 390740, 390741, 390745, 390968, 396112, 396113, 365813, 436358, 436362, 320156, 320160, 320163, 320164, 156080, 156091, 18724, 18725, 126757, 128266, 449417, 449437, 469693, 472154, 477180)) 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,533717,533732,369969,370995,371710,379251,390740,390741,390745,390968,396112,396113,365813,436358,436362,320156,320160,320163,320164,156080,156091,18724,18725,126757,128266,449417,449437,469693,472154,477180)
-
SKU: BNR-A3883TS6PRO
Model: A3883TS6PRO
Condition: New-In-Box
-
SKU: BNR-TAD18A
Model: BNR-TAD18A
Condition: New-In-Box
-
SKU: BNR-QRC70
Model: QRC70
Condition: New-In-Box
-
SKU: BNR-TTOR14CGX25
Model: TTOR14CGX25
Condition: New-In-Box
-
SKU: BNR-101100
Model: C373FBV6H
Condition: New-In-Box
-
SKU: BNR-00215
Model: TABLEPODKIT
Condition: New-In-Box
-
SKU: BNR-00125
Model: ACSM360D
Condition: New-In-Box
-
SKU: BNR-00126
Model: ACSMKS
Condition: New-In-Box
-
SKU: BNR-00127
Model: ACSMSA
Condition: New-In-Box
-
SKU: BNR-20010
Model: HYDRA2
Condition: New-In-Box
-
SKU: BNR-GHF2
Model: GH2F
Condition: New-In-Box
-
SKU: BNR-GDHAD1
Model: GDHAD1
Condition: New-In-Box
-
SKU: BNR-PU30
Model: PU30
Condition: New-In-Box
-
SKU: BNR-100300
Model: KP1
Condition: New-In-Box
-
SKU: BNR-100301
Model: KP1K
Condition: New-In-Box
-
SKU: BNR-FBAT15CVX20
Model: FBAT15CVX20
Condition: New-In-Box
-
SKU: BNR-GX35
Model: GX35
Condition: New-In-Box
-
SKU: BNR-VX20
Model: VX20
Condition: New-In-Box
-
SKU: BNR-VX25
Model: VX25
Condition: New-In-Box
-
SKU: BNR-MMA28C
Model: MMA28C
Condition: New-In-Box
-
SKU: BNR-TMA27C
Model: TMA27C
Condition: New-In-Box
-
SKU: BNR-101062G
Model: C2350Q2G
Condition: New-In-Box
-
SKU: BNR-101062R
Model: C2350Q2R
Condition: New-In-Box
-
SKU: BNR-FPA29AB1
Model: FPA29AB1
Condition: New-In-Box
-
SKU: BNR-MPH300TA
Model: MPH300TA
Condition: New-In-Box
-
SKU: BNR-FBAT03CNMVX20
Model: FBAT03CNMVX20
Condition: New-In-Box
-
SKU: BNR-FBAT24CVX25
Model: FBAT24CVX25
Condition: New-In-Box
-
SKU: BNR-100303
Model: TPKWE
Condition: New-In-Box
-
SKU: BNR-GH2N
Model: GH2N
Condition: New-In-Box
-
SKU: BNR-TMTH44C
Model: TMTH44C
Condition: New-In-Box