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 (367601, 415618, 417123, 417124, 417203, 417205, 417206, 417208, 438369, 438370, 531382, 533955, 533957, 533959, 533960, 485673, 486216, 486217, 486218, 490224, 490227, 490229, 490230, 490231, 490232, 494815, 498526, 498528, 498531, 498551)) 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,367601,415618,417123,417124,417203,417205,417206,417208,438369,438370,531382,533955,533957,533959,533960,485673,486216,486217,486218,490224,490227,490229,490230,490231,490232,494815,498526,498528,498531,498551)
View as Grid List

Items 91-120 of 155

per page
Set Ascending Direction
  1. FPV Fly More Kit
    DJI FPV Fly More Kit
    USD $299.00
    Out of stock
    SKU: DJI-01205
    Model: CP.FP.00000021.01
    Condition: New-In-Box
  2. Action 2 Dual-Screen Combo
    DJI Action 2 Dual-Screen Combo
    USD $309.00
    Out of stock
    SKU: DJI-01704
    Model: CP.OS.00000183.01
    Condition: New-In-Box
  3. Mavic 3 Fly More Combo
    DJI Mavic 3 Fly More Combo
    USD $2,749.00
    Out of stock
    SKU: DJI-00446
    Model: CP.MA.00000440.01
    Condition: New-In-Box
  4. Mavic 3
    DJI Mavic 3
    USD $2,049.00
    Out of stock
    SKU: DJI-00445
    Model: CP.MA.00000439.01
    Condition: New-In-Box
  5. RC Pro for Mavic 3
    DJI RC Pro for Mavic 3
    USD $1,199.00
    Out of stock
    SKU: DJI-00500
    Model: CP.MA.00000406.01
    Condition: New-In-Box
  6. Mavic 3 ND Filters Set (ND4/8/16/32)
    DJI Mavic 3 ND Filters Set (ND4/8/16/32)
    USD $179.00
    Out of stock
    SKU: DJI-00503
    Model: CP.MA.00000429.01
    Condition: New-In-Box
  7. Mavic 3 Wide-Angle Lens
    DJI Mavic 3 Wide-Angle Lens
    USD $179.00
    Out of stock
    SKU: DJI-00502
    Model: CP.MA.00000433.01
    Condition: New-In-Box
  8. Mavic 3 ND Filters Set (ND64/128/256/512)
    SKU: DJI-00504
    Model: CP.MA.00000430.01
    Condition: New-In-Box
  9. Inspire 2 X5S Standard Kit
    DJI Inspire 2 X5S Standard Kit
    USD $5,299.00
    Out of stock
    SKU: DJI-02230
    Model: CP.IN.00000014.01
    Condition: New-In-Box
  10. Battery Station
    DJI Battery Station
    USD $1,499.00
    Out of stock
    SKU: DJI-02231
    Model: CP.BX.00000013.01
    Condition: New-In-Box
  11. Matrice 30 Series 1671 Propellers
    DJI Matrice 30 Series 1671 Propellers
    USD $49.00
    Out of stock
    SKU: DJI-00904
    Model: CP.EN.00000379.01
    Condition: New-In-Box
  12. Avata Pro-View Combo with DJI RC Motion 2
    DJI Avata Pro-View Combo with DJI RC Motion 2
    USD $1,428.00
    Out of stock
    SKU: DJI-03201A
    Model: CP.FP.00000129.01
    Condition: New-In-Box
  13. RC Motion 2
    DJI RC Motion 2
    USD $239.00
    Out of stock
    SKU: DJI-01227
    Model: CP.RC.00000007.01
    Condition: New-In-Box
  14. Avata Explorer Combo
    DJI Avata Explorer Combo
    USD $1,278.00
    Out of stock
    SKU: DJI-03208
    Model: CP.FP.00000130.01
    Condition: New-In-Box
  15. Goggles Integra
    DJI Goggles Integra
    USD $349.00
    Out of stock
    SKU: DJI-01226
    Model: CP.FP.00000113.01
    Condition: New-In-Box
  16. Mini 2 Intelligent Flight Battery
    DJI Mini 2 Intelligent Flight Battery
    USD $59.97
    Out of stock
    SKU: DJI-01149
    Model: CP.MA.00000326.01
    Condition: New-In-Box
  17. Osmo Action 3 Standard Combo
    DJI Osmo Action 3 Standard Combo
    USD $329.00
    Out of stock
    SKU: DJI-01800
    Model: CP.OS.00000220.01
    Condition: New-In-Box
  18. DJI-Action 3 Adventure Combo C
    DJI DJI-Action 3 Adventure Combo C
    USD $439.00
    Out of stock
    SKU: DJI-01801
    Model: CP.OS.00000221.01
    Condition: New-In-Box
  19. Osmo Action 3 Extreme Battery
    DJI Osmo Action 3 Extreme Battery
    USD $29.00
    Out of stock
    SKU: DJI-01810
    Model: CP.OS.00000229.01
    Condition: New-In-Box
  20. Mavic 3 Enterprise Series Battery Kit
    DJI Mavic 3 Enterprise Series Battery Kit
    USD $659.00
    Out of stock
    SKU: DJI-600300
    Model: CP.EN.00000421.01
    Condition: New-In-Box
  21. Mavic 3 Enterprise Series Battery Charging Hub
    SKU: DJI-600301
    Model: CP.EN.00000422.01
    Condition: New-In-Box
  22. 100W USB-C Power Adapter
    DJI 100W USB-C Power Adapter
    USD $95.00
    Out of stock
    SKU: DJI-600302
    Model: CP.EN.00000424.01
    Condition: New-In-Box
  23. Mavic 3 Enterprise Series RTK Module
    DJI Mavic 3 Enterprise Series RTK Module
    USD $709.00
    Out of stock
    SKU: DJI-600303
    Model: CP.EN.00000417.01
    Condition: New-In-Box
  24. Mavic 3 Enterprise Series Speaker
    DJI Mavic 3 Enterprise Series Speaker
    USD $159.00
    Out of stock
    SKU: DJI-600304
    Model: CP.EN.00000418.01
    Condition: New-In-Box
  25. Mavic 3 Enterprise Series Propellers
    DJI Mavic 3 Enterprise Series Propellers
    USD $19.00
    Out of stock
    SKU: DJI-600305
    Model: CP.EN.00000430.01
    Condition: New-In-Box
  26. Transmission (High-Bright Monitor Combo)
    DJI Transmission (High-Bright Monitor Combo)
    USD $2,499.00
    Out of stock
    SKU: DJI-00460
    Model: CP.RN.00000209.01
    Condition: New-In-Box
  27. Mavic 3 Classic ND Filters Set (ND8/16/32/64)
    SKU: DJI-00454
    Model: CP.MA.00000561.01
    Condition: New-In-Box
  28. Mavic 3 Battery Charging Hub (100W)
    DJI Mavic 3 Battery Charging Hub (100W)
    USD $99.00
    Out of stock
    SKU: DJI-00455
    Model: CP.EN.00000422.01
    Condition: New-In-Box
  29. Mavic 3 Classic Wide-Angle Lens
    DJI Mavic 3 Classic Wide-Angle Lens
    USD $129.00
    Out of stock
    SKU: DJI-00456
    Model: CP.MA.00000562.01
    Condition: New-In-Box
  30. Mavic 3 Classic (Drone Only)
    DJI Mavic 3 Classic (Drone Only)
    USD $1,179.00
    Out of stock
    SKU: DJI-00450
    Model: CP.MA.00000596.01
    Condition: New-In-Box
View as Grid List

Items 91-120 of 155

per page
Set Ascending Direction