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 (604503, 602921, 602851, 602849, 602835, 598325, 598323, 588538, 588536, 581794, 581791, 581781, 578273, 578271, 578045, 571056, 571002, 571001, 569197, 569196, 565994, 565992, 565991, 565990, 565989, 565988, 565985, 565983, 543148, 542725)) 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,604503,602921,602851,602849,602835,598325,598323,588538,588536,581794,581791,581781,578273,578271,578045,571056,571002,571001,569197,569196,565994,565992,565991,565990,565989,565988,565985,565983,543148,542725)
-
[Black, White]
SKU: DJI-MIC 2 TRANSMITTER ONLY
Model: CP.RN.00000328.02, CP.RN.00000329.01
Condition: New-In-Box
-
SKU: DJI-04905
Model: CP.RN.00000327.02
Condition: New-In-Box
-
SKU: DJI-04909
Model: CP.RN.00000331.01
Condition: New-In-Box
-
SKU: DJI-04908
Model: CP.RN.00000330.01
Condition: New-In-Box
-
SKU: DJI-04904
Model: CP.RN.00000325.02
Condition: New-In-Box
-
SKU: DJI-05015
Model: CP.RN.00000341.01
Condition: New-In-Box
-
SKU: DJI-05014
Model: CP.RN.00000351.01
Condition: New-In-Box
-
SKU: DJI-01611
Model: CP.OS.00000302.01
Condition: New-In-Box
-
SKU: DJI-01610
Model: CP.OS.00000301.01
Condition: New-In-Box
-
SKU: DJI-263204
Model: CP.MA.00000735.01
Condition: New-In-Box
-
SKU: DJI-263202
Model: CP.MA.00000732.01
Condition: New-In-Box
-
SKU: DJI-263200
Model: CP.MA.00000731.01
Condition: New-In-Box
-
SKU: DJI-263211
Model: CP.MA.00000729.02
Condition: New-In-Box
-
SKU: DJI-263210
Model: CP.MA.00000756.01
Condition: New-In-Box
-
SKU: DJI-263206
Model: CP.MA.00000740.01
Condition: New-In-Box
-
SKU: DJI-03210
Model: CP.FP.00000077.01
Condition: New-In-Box
-
SKU: DJI-00462
Model: CP.RN.00000319.01
Condition: New-In-Box
-
SKU: DJI-00461
Model: CP.RN.00000318.01
Condition: New-In-Box
-
SKU: DJI-09511
Model: CP.OS.00000270.01
Condition: New-In-Box
-
SKU: DJI-09510
Model: CP.OS.00000269.01
Condition: New-In-Box
-
SKU: DJI-01194
Model: CP.QT.00008567.01
Condition: New-In-Box
-
SKU: DJI-01193
Model: CP.MA.00000702.01
Condition: New-In-Box
-
SKU: DJI-01192
Model: CP.MA.00000700.01
Condition: New-In-Box
-
SKU: DJI-01191
Model: CP.MA.00000701.01
Condition: New-In-Box
-
SKU: DJI-01190
Model: CP.MA.00000699.01
Condition: New-In-Box
-
SKU: DJI-01186
Model: CP.MA.00000693.01
Condition: New-In-Box
-
SKU: DJI-01185
Model: CP.MA.00000692.01
Condition: New-In-Box
-
SKU: DJI-01184
Model: CP.MA.00000691.01
Condition: New-In-Box
-
SKU: DJI-600410
Model: CP.MA.00000426.01
Condition: New-In-Box
-
SKU: DJI-600401
Model: CP.MA.00000654.01
Condition: New-In-Box