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 (161387, 533717, 533732, 370995, 371710, 390740, 390741, 390745, 390968, 396113, 449417, 449422, 449437, 469693, 472154, 477180, 477181, 477182, 477183, 365813, 369778, 369969, 436358, 436362, 320158, 320164, 18724, 18725, 126757, 128266)) 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,161387,533717,533732,370995,371710,390740,390741,390745,390968,396113,449417,449422,449437,469693,472154,477180,477181,477182,477183,365813,369778,369969,436358,436362,320158,320164,18724,18725,126757,128266)
-
SKU: BNR-C08D6B
Model: C08D6B
Condition: New-In-Box
-
SKU: BNR-A3883TS6PRO
Model: A3883TS6PRO
Condition: New-In-Box
-
SKU: BNR-TAD18A
Model: BNR-TAD18A
Condition: New-In-Box
-
SKU: BNR-TTOR14CGX25
Model: TTOR14CGX25
Condition: New-In-Box
-
SKU: BNR-101100
Model: C373FBV6H
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-GDHAD1
Model: GDHAD1
Condition: New-In-Box
-
SKU: BNR-FBAT03CNMVX20
Model: FBAT03CNMVX20
Condition: New-In-Box
-
SKU: BNR-FBAT05AVX20
Model: FBAT05AVX20
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
-
SKU: BNR-TMTH44CWH15
Model: TMTH44CWH15
Condition: New-In-Box
-
SKU: BNR-QRX10
Model: QRX10
Condition: New-In-Box
-
SKU: BNR-WH15
Model: WH15
Condition: New-In-Box
-
SKU: BNR-PU30
Model: PU30
Condition: New-In-Box
-
SKU: BNR-00124
Model: ARCASMART70
Condition: New-In-Box
-
SKU: BNR-QRC70
Model: QRC70
Condition: New-In-Box
-
SKU: BNR-100300
Model: KP1
Condition: New-In-Box
-
SKU: BNR-100301
Model: KP1K
Condition: New-In-Box
-
SKU: BNR-GX25
Model: GX25
Condition: New-In-Box
-
SKU: BNR-VX25
Model: VX25
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