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 (608395, 608394, 593026, 451057, 466020, 353659, 367202, 420062, 265285, 265286, 265287, 265288, 265324, 265325, 320155, 65598, 65611, 65974, 65997, 18638, 18719, 38186, 87198, 114451, 114452, 114458, 141141, 141142, 141145, 156068)) 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,608395,608394,593026,451057,466020,353659,367202,420062,265285,265286,265287,265288,265324,265325,320155,65598,65611,65974,65997,18638,18719,38186,87198,114451,114452,114458,141141,141142,141145,156068)
-
SKU: BNR-KH26PC
Model: KH26PC
Condition: New-In-Box
-
SKU: BNR-KH25PC
Model: KH25PC
Condition: New-In-Box
-
SKU: BNR-TSSL08AN00P
Model: TSSL08AN00P
Condition: New-In-Box
-
SKU: BNR-A1573FS2PRO
Model: A1573FS2PRO
Condition: New-In-Box
-
SKU: BNR-A1683TS2PRO
Model: A1683TS2PRO
Condition: New-In-Box
-
SKU: BNR-00140
Model: KH26P
Condition: New-In-Box
-
SKU: BNR-KH25P
Model: KH25P
Condition: New-In-Box
-
SKU: BNR-FSL09AN00
Model: FSL09AN00
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-A48FDS4PRO
Model: A48FDS4PRO
Condition: New-In-Box
-
SKU: BNR-A48FDS6PRO
Model: A48FDS6PRO
Condition: New-In-Box
-
SKU: BNR-FBAT15AVX20
Model: FBAT15AVX20
Condition: New-In-Box
-
SKU: BNR-BV4PRO
Model: BV4PRO
Condition: New-In-Box
-
SKU: BNR-BV6PRO
Model: BV6PRO
Condition: New-In-Box
-
SKU: BNR-MAD38A
Model: MAD38A
Condition: New-In-Box
-
SKU: BNR-TAD28AIB2
Model: TAD28AIB2
Condition: New-In-Box
-
SKU: BNR-100714A
Model: A48FD
Condition: New-In-Box
-
SKU: BNR-100285R
Model: A2350Q2R
Condition: New-In-Box
-
SKU: BNR-TAD28A
Model: TAD28A
Condition: New-In-Box
-
SKU: BNR-FGP18A
Model: FGP18A
Condition: New-In-Box
-
SKU: BNR-A673TM
Model: A673TM
Condition: New-In-Box
-
SKU: BNR-A674TM
Model: A674TM
Condition: New-In-Box
-
SKU: BNR-TSL08AN00
Model: TSL08AN00
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