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 (156069, 156070, 156076, 156077, 156078, 156079, 156086, 156090, 156093, 156096, 156690, 161387, 129643, 129644, 129647, 139520, 17845, 18628, 18638, 18719, 15683, 15687, 14795, 14796, 21230, 23533, 38186, 65584, 65598, 65611)) 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,156069,156070,156076,156077,156078,156079,156086,156090,156093,156096,156690,161387,129643,129644,129647,139520,17845,18628,18638,18719,15683,15687,14795,14796,21230,23533,38186,65584,65598,65611)
-
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: BNR-B1
Model: B1
Condition: New-In-Box
-
SKU: BNR-B4
Model: B4
Condition: New-In-Box
-
SKU: BNR-BL100
Model: Bl100
Condition: New-In-Box
-
SKU: BNR-BS04
Model: BS04
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-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-00110
Model: PMU50M
Condition: New-In-Box
-
SKU: BNR-101511
Model: QR11
Condition: New-In-Box
-
SKU: BNR-TAD28A
Model: TAD28A
Condition: New-In-Box
-
SKU: BNR-B3
Model: B3
Condition: New-In-Box
-
SKU: BNR-BV4PRO
Model: BV4PRO
Condition: New-In-Box
-
SKU: BNR-BV6PRO
Model: BV6PRO
Condition: New-In-Box