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 (38186, 87198, 87199, 87203, 89719, 89720, 105641, 114451, 114452, 114453, 114454, 114458, 114459, 17845, 18628, 18638, 18719, 370982, 379251, 379252, 404807, 420062, 420064, 420112, 436364, 449429, 451057, 452386, 466020, 477179)) 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,38186,87198,87199,87203,89719,89720,105641,114451,114452,114453,114454,114458,114459,17845,18628,18638,18719,370982,379251,379252,404807,420062,420064,420112,436364,449429,451057,452386,466020,477179)
-
SKU: BNR-TAD28A
Model: TAD28A
Condition: New-In-Box
-
SKU: BNR-FGP18A
Model: FGP18A
Condition: New-In-Box
-
SKU: BNR-FGP28A
Model: FGP28A
Condition: New-In-Box
-
SKU: BNR-IN00
Model: IN00
Condition: New-In-Box
-
SKU: BNR-BL100S
Model: BL100S
Condition: New-In-Box
-
SKU: BNR-BL75S
Model: BL75S
Condition: New-In-Box
-
SKU: BNR-BL75
Model: BL75
Condition: New-In-Box
-
SKU: BNR-A673TM
Model: A673TM
Condition: New-In-Box
-
SKU: BNR-A674TM
Model: A674TM
Condition: New-In-Box
-
SKU: BNR-BV10H
Model: BV10H
Condition: New-In-Box
-
SKU: BNR-BV8H
Model: BV8H
Condition: New-In-Box
-
SKU: BNR-TSL08AN00
Model: TSL08AN00
Condition: New-In-Box
-
SKU: BNR-TSL08CN00
Model: TSL08CN00
Condition: New-In-Box
-
SKU: IND-458008
Model: PH08
Condition: New-In-Box
-
SKU: BNR-00130
Model: VT2
Condition: New-In-Box
-
SKU: BNR-100714A
Model: A48FD
Condition: New-In-Box
-
SKU: BNR-100285R
Model: A2350Q2R
Condition: New-In-Box
-
SKU: BNR-FRHN05CVX20
Model: FRHN05CVX20
Condition: New-In-Box
-
SKU: BNR-00215
Model: TABLEPODKIT
Condition: New-In-Box
-
SKU: BNR-00216
Model: TABLEPODPROKIT
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-FBAT05CVX20
Model: FBAT05CVX20
Condition: New-In-Box
-
SKU: BNR-A1573FS2PRO
Model: A1573FS2PRO
Condition: New-In-Box
-
SKU: BNR-GH5CMINI
Model: GH5CMINI
Condition: New-In-Box
-
SKU: BNR-A1683TS2PRO
Model: A1683TS2PRO
Condition: New-In-Box
-
SKU: BNR-BVX18CFKPRO
Model: BVX18CFKPRO
Condition: New-In-Box