DJI

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)
View as Grid List

Items 1-30 of 155

Page
per page
Set Ascending Direction
  1. Mic 2 Transmitter
    DJI Mic 2 Transmitter
    Out of stock
    [Black, White]
    SKU: DJI-MIC 2 TRANSMITTER ONLY
    Model: CP.RN.00000328.02, CP.RN.00000329.01
    Condition: New-In-Box
  2. Mic 2 (1 TX + 1 RX)
    DJI Mic 2 (1 TX + 1 RX)
    USD $219.00
    SKU: DJI-04905
    Model: CP.RN.00000327.02
    Condition: New-In-Box
  3. Lavalier Mic
    DJI Lavalier Mic
    USD $39.00
    SKU: DJI-04909
    Model: CP.RN.00000331.01
    Condition: New-In-Box
  4. Mic 2 Charging Case
    DJI Mic 2 Charging Case
    USD $69.00
    Out of stock
    SKU: DJI-04908
    Model: CP.RN.00000330.01
    Condition: New-In-Box
  5. Mic 2 (2 TX + 1 RX + Charging Case)
    DJI Mic 2 (2 TX + 1 RX + Charging Case)
    USD $349.00
    Out of stock
    SKU: DJI-04904
    Model: CP.RN.00000325.02
    Condition: New-In-Box
  6. Zenmuse X9-8K Gimbal Camera
    DJI Zenmuse X9-8K Gimbal Camera
    USD $3,599.00
    Out of stock
    SKU: DJI-05015
    Model: CP.RN.00000341.01
    Condition: New-In-Box
  7. Ronin 4D 4-Axis Cinema Camera 8K Combo
    DJI Ronin 4D 4-Axis Cinema Camera 8K Combo
    USD $12,838.00
    Out of stock
    SKU: DJI-05014
    Model: CP.RN.00000351.01
    Condition: New-In-Box
  8. Osmo Pocket 3 Creator Combo
    DJI Osmo Pocket 3 Creator Combo
    USD $669.00
    Out of stock
    SKU: DJI-01611
    Model: CP.OS.00000302.01
    Condition: New-In-Box
  9. Osmo Pocket 3
    DJI Osmo Pocket 3
    USD $519.00
    SKU: DJI-01610
    Model: CP.OS.00000301.01
    Condition: New-In-Box
  10. Mini 4 Pro Fly More Combo (DJI RC 2)
    DJI Mini 4 Pro Fly More Combo (DJI RC 2)
    USD $1,099.00
    SKU: DJI-263204
    Model: CP.MA.00000735.01
    Condition: New-In-Box
  11. Mini 4 Pro (DJI RC 2)
    DJI Mini 4 Pro (DJI RC 2)
    USD $959.00
    SKU: DJI-263202
    Model: CP.MA.00000732.01
    Condition: New-In-Box
  12. Mini 4 Pro (DJI RC-N2)
    DJI Mini 4 Pro (DJI RC-N2)
    USD $759.00
    SKU: DJI-263200
    Model: CP.MA.00000731.01
    Condition: New-In-Box
  13. Mini 4 Pro ND Filters Set (ND16/64/256)
    SKU: DJI-263211
    Model: CP.MA.00000729.02
    Condition: New-In-Box
  14. Mini 4 Pro Intelligent Flight Battery
    DJI Mini 4 Pro Intelligent Flight Battery
    USD $65.00
    SKU: DJI-263210
    Model: CP.MA.00000756.01
    Condition: New-In-Box
  15. Mini 4 Pro Fly More Combo Plus (DJI RC 2)
    DJI Mini 4 Pro Fly More Combo Plus (DJI RC 2)
    USD $1,159.00
    SKU: DJI-263206
    Model: CP.MA.00000740.01
    Condition: New-In-Box
  16. Avata ND Filters Set (ND8/16/32)
    DJI Avata ND Filters Set (ND8/16/32)
    USD $79.00
    Out of stock
    SKU: DJI-03210
    Model: CP.FP.00000077.01
    Condition: New-In-Box
  17. Wireless Video Receiver
    DJI Wireless Video Receiver
    USD $1,699.00
    Out of stock
    SKU: DJI-00462
    Model: CP.RN.00000319.01
    Condition: New-In-Box
  18. Transmission (Standard Combo)
    DJI Transmission (Standard Combo)
    USD $2,499.00
    Out of stock
    SKU: DJI-00461
    Model: CP.RN.00000318.01
    Condition: New-In-Box
  19. Osmo Action 4 Adventure Combo
    DJI Osmo Action 4 Adventure Combo
    USD $499.00
    Out of stock
    SKU: DJI-09511
    Model: CP.OS.00000270.01
    Condition: New-In-Box
  20. Osmo Action 4 Standard Combo
    DJI Osmo Action 4 Standard Combo
    USD $399.00
    SKU: DJI-09510
    Model: CP.OS.00000269.01
    Condition: New-In-Box
  21. Care Refresh 1-Year Plan for DJI Air 3
    DJI Care Refresh 1-Year Plan for DJI Air 3
    USD $109.00
    Out of stock
    SKU: DJI-01194
    Model: CP.QT.00008567.01
    Condition: New-In-Box
  22. Air 3 Low-Noise Propellers (Pair)
    DJI Air 3 Low-Noise Propellers (Pair)
    USD $12.00
    Out of stock
    SKU: DJI-01193
    Model: CP.MA.00000702.01
    Condition: New-In-Box
  23.  Air 3 ND Filters Set (ND8/16/32/64)
    DJI Air 3 ND Filters Set (ND8/16/32/64)
    USD $99.00
    SKU: DJI-01192
    Model: CP.MA.00000700.01
    Condition: New-In-Box
  24. Air 3 Intelligent Flight Battery
    DJI Air 3 Intelligent Flight Battery
    USD $159.00
    SKU: DJI-01191
    Model: CP.MA.00000701.01
    Condition: New-In-Box
  25. Air 3 Battery Charging Hub
    DJI Air 3 Battery Charging Hub
    USD $69.00
    SKU: DJI-01190
    Model: CP.MA.00000699.01
    Condition: New-In-Box
  26. Air 3 Fly More Combo with DJI RC 2
    DJI Air 3 Fly More Combo with DJI RC 2
    USD $1,549.00
    Out of stock
    SKU: DJI-01186
    Model: CP.MA.00000693.01
    Condition: New-In-Box
  27. Air 3 Fly More Combo with DJI RC-N2
    DJI Air 3 Fly More Combo with DJI RC-N2
    USD $1,349.00
    SKU: DJI-01185
    Model: CP.MA.00000692.01
    Condition: New-In-Box
  28. Air 3 with DJI RC-N2
    DJI Air 3 with DJI RC-N2
    USD $1,099.00
    SKU: DJI-01184
    Model: CP.MA.00000691.01
    Condition: New-In-Box
  29. 65W Car Charger for DJI Mavic 3
    DJI 65W Car Charger for DJI Mavic 3
    USD $79.00
    SKU: DJI-600410
    Model: CP.MA.00000426.01
    Condition: New-In-Box
  30. DJI Mavic 3 Pro (DJI RC)
    DJI DJI Mavic 3 Pro (DJI RC)
    USD $2,199.00
    Out of stock
    SKU: DJI-600401
    Model: CP.MA.00000654.01
    Condition: New-In-Box
View as Grid List

Items 1-30 of 155

Page
per page
Set Ascending Direction