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 (65988, 65989, 65990, 65991, 65992, 65997, 77724, 15683, 15687, 14795, 14796, 330812, 353659, 367202, 369775, 369776, 369778, 370982, 379252, 404807, 420062, 420064, 420112, 436364, 449422, 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,65988,65989,65990,65991,65992,65997,77724,15683,15687,14795,14796,330812,353659,367202,369775,369776,369778,370982,379252,404807,420062,420064,420112,436364,449422,449429,451057,452386,466020,477179)
-
SKU: BNR-PL150
Model: PL150
Condition: New-In-Box
-
SKU: BNR-PL200
Model: PL200
Condition: New-In-Box
-
SKU: BNR-PL85
Model: PL85
Condition: New-In-Box
-
SKU: BNR-PU6080
Model: PU6080
Condition: New-In-Box
-
SKU: BNR-PP1
Model: PP1
Condition: New-In-Box
-
SKU: BNR-TAD28AIB2
Model: TAD28AIB2
Condition: New-In-Box
-
SKU: BNR-PU60
Model: PU60
Condition: New-In-Box
-
SKU: BNR-101062T
Model: C2350Q2T
Condition: New-In-Box
-
SKU: BNR-101060T
Model: C1350Q1T
Condition: New-In-Box
-
SKU: BNR-101014
Model: B2 Ball Head
Condition: New-In-Box
-
SKU: BNR-101032
Model: BH00 Single Action Ballhead
Condition: New-In-Box
-
SKU: BNR-S2PRO
Model: S2PRO
Condition: New-In-Box
-
SKU: BNR-00140
Model: KH26P
Condition: New-In-Box
-
SKU: BNR-KH25P
Model: KH25P
Condition: New-In-Box
-
SKU: BNR-101602
Model: MSD46C
Condition: New-In-Box
-
SKU: BNR-101604
Model: MSDPL46C
Condition: New-In-Box
-
SKU: BNR-00124
Model: ARCASMART70
Condition: New-In-Box
-
SKU: BNR-FRHN05CVX20
Model: FRHN05CVX20
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-FBAT05AVX20
Model: FBAT05AVX20
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