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 (129647, 139520, 141141, 141142, 141145, 156068, 156069, 156070, 156076, 156077, 156078, 156079, 156086, 156090, 156093, 156096, 156690, 161387, 17845, 18628, 18638, 18719, 21230, 38186, 87198, 87199, 87203, 89719, 89720, 65584)) 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,129647,139520,141141,141142,141145,156068,156069,156070,156076,156077,156078,156079,156086,156090,156093,156096,156690,161387,17845,18628,18638,18719,21230,38186,87198,87199,87203,89719,89720,65584)
-
SKU: BNR-BL100
Model: Bl100
Condition: New-In-Box
-
SKU: BNR-BS04
Model: BS04
Condition: New-In-Box
-
SKU: BNR-BV4
Model: A373FBV4H
Condition: New-In-Box
-
SKU: BNR-BV6
Model: A373FBV6H
Condition: New-In-Box
-
SKU: BNR-FTA28AB1
Model: FTA28AB1
Condition: New-In-Box
-
SKU: BNR-00208
Model: BV8
Condition: New-In-Box
-
SKU: BNR-00210
Model: BV10
Condition: New-In-Box
-
SKU: BNR-100710A
Model: A38FD
Condition: New-In-Box
-
SKU: BNR-IB1
Model: IB1
Condition: New-In-Box
-
SKU: BNR-IB2
Model: IB2
Condition: New-In-Box
-
SKU: BNR-MAD49A
Model: MAD49A
Condition: New-In-Box
-
SKU: BNR-MAD49C
Model: MAD49C
Condition: New-In-Box
-
SKU: BNR-TAD28CB2
Model: TAD28CB2
Condition: New-In-Box
-
SKU: BNR-TMA27A
Model: TMA27A
Condition: New-In-Box
-
SKU: BNR-TMA38CL
Model: TMA38CL
Condition: New-In-Box
-
SKU: BRN-33.489.00
Model: B-33.489.00
Condition: New-In-Box
-
SKU: BNR-DL06
Model: DL06
Condition: New-In-Box
-
SKU: BNR-C08D6B
Model: C08D6B
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-00110
Model: PMU50M
Condition: New-In-Box
-
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-B3
Model: B3
Condition: New-In-Box