Azden Corporation

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 (16710, 14774, 12276, 7300, 8900, 9637, 9638, 9640, 200, 202, 18421, 19163, 21179, 21180, 21989, 37638, 72863, 72884, 72885, 72888, 132618, 132630, 119991, 120049, 120050, 120051)) 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,16710,14774,12276,7300,8900,9637,9638,9640,200,202,18421,19163,21179,21180,21989,37638,72863,72884,72885,72888,132618,132630,119991,120049,120050,120051)
View as Grid List

26 Items

per page
Set Ascending Direction
  1. Azden Corporation BC-27H AC Adapter
    USD $36.97
    Out of stock
    SKU: AZD-00500
    Model: BC-27H
    Condition: New-In-Box
  2. SMX-5 Stereo Microphone
    Azden Corporation SMX-5 Stereo Microphone
    USD $65.00
    Out of stock
    SKU: AZD-00053
    Model: SMX-5
    Condition: New-In-Box
  3. 330LH UHF Wirelss Lav and Handheld Mic System
    Azden Corporation 330LH UHF Wirelss Lav and Handheld Mic System
    USD $850.00
    Out of stock
    SKU: AZD-00013C
    Model: 330LH
    Condition: New-In-Box
  4. 330UPR Top View
    Azden Corporation 330ULT UHF Wireless Mic System With Dual Lav Mics
    USD $775.00
    Out of stock
    SKU: AZD-00013E
    Model: 330ULT
    Condition: New-In-Box
  5. EX-503 Omni-Directional Lavalier Microphone
    Azden Corporation EX-503 Omni-Directional Lavalier Microphone
    USD $26.00
    Out of stock
    SKU: AZD-00030
    Model: EX-503
    Condition: New-In-Box
  6. SGM-1X Pro Shotgun Microphone with XLR Output
    Azden Corporation SGM-1X Pro Shotgun Microphone with XLR Output
    USD $179.00
    Out of stock
    SKU: AZD-00023
    Model: SGM-1X
    Condition: New-In-Box
  7. WMS-PRO Microphone System
    Azden Corporation WMS-PRO Microphone System
    USD $159.00
    Out of stock
    SKU: AZD-00040
    Model: WMSPRO
    Condition: New-In-Box
  8. SWS-200 High Performance Softie Wind-Shield
    Azden Corporation SWS-200 High Performance Softie Wind-Shield
    USD $69.00
    Out of stock
    SKU: AZD-00060
    Model: SWS-200
    Condition: New-In-Box
  9. VHF Handheld Microphone/Transmitter
    Azden Corporation VHF Handheld Microphone/Transmitter
    USD $120.00
    Out of stock
    SKU: AZD-00032
    Model: 31HT
    Condition: New-In-Box
  10. SMX-10 Directional Stereo Mic with Stereo Mini output
    Azden Corporation SMX-10 Directional Stereo Mic with Stereo Mini output
    USD $85.00
    Out of stock
    SKU: AZD-00055
    Model: SMX-10
    Condition: New-In-Box
  11. WLX-PRO+i  VHF Wireless Microphone System for Smartphones and Tablets
    SKU: AZD-00004
    Model: WLX-PRO+i
    Condition: New-In-Box
  12. i-Coustics EX-503i Studio Pro Lapel Microphone for Smartphones and Tablets
    SKU: AZD-00031
    Model: EX-503I
    Condition: New-In-Box
  13. SGM-990+i Shotgun Microphone for Mobile Device Recording
    Azden Corporation SGM-990+i Shotgun Microphone for Mobile Device Recording
    USD $95.00
    Out of stock
    SKU: AZD-00029
    Model: SGM-990+I
    Condition: New-In-Box
  14. HX-Mi TRRS Mic Headphone Cable
    Azden Corporation HX-Mi TRRS Mic Headphone Cable
    USD $20.00
    Out of stock
    SKU: AZD-00080
    Model: HX-MI
    Condition: New-In-Box
  15. WMS-PRO+i VHF Wireless Microphone System for Smartphones and Tablets
    SKU: AZD-00068
    Model: WMS-PRO+I
    Condition: New-In-Box
  16. WDL-PRO  2-Channel VHF Wireless Microphone System
    Azden Corporation WDL-PRO 2-Channel VHF Wireless Microphone System
    USD $399.00
    Out of stock
    SKU: AZD-00072
    Model: WDL-PRO
    Condition: New-In-Box
  17. SGM-250 Professional Dual Powered Shotgun Microphone
    Azden Corporation SGM-250 Professional Dual Powered Shotgun Microphone
    USD $249.00
    Out of stock
    SKU: AZD-00021
    Model: SGM-250
    Condition: New-In-Box
  18. SMX-15 Powered Shotgun Video Microphone
    Azden Corporation SMX-15 Powered Shotgun Video Microphone
    USD $199.00
    Out of stock
    SKU: AZD-00057
    Model: SMX-15
    Condition: New-In-Box
  19. SMX-30 Stereo/Mono Switchable Video Microphone
    Azden Corporation SMX-30 Stereo/Mono Switchable Video Microphone
    USD $249.00
    Out of stock
    SKU: AZD-00058
    Model: SMX-30
    Condition: New-In-Box
  20. PRO-XD Digital Wireless Microphone System
    Azden Corporation PRO-XD Digital Wireless Microphone System
    USD $199.00
    Out of stock
    SKU: AZD-00078
    Model: PRO-XD
    Condition: New-In-Box
  21. SMX-20 Compact Directional Stereo Microphone
    Azden Corporation SMX-20 Compact Directional Stereo Microphone
    USD $149.99
    Out of stock
    SKU: AZQ-00059
    Model: SMX-20
    Condition: New-In-Box
  22. WS-SLR Foam Windscreen
    Azden Corporation WS-SLR Foam Windscreen
    USD $18.00
    Out of stock
    SKU: AZD-00065
    Model: WS-SLR
    Condition: New-In-Box
  23. SWS-100 High Performance Faux Fur Windshield
    Azden Corporation SWS-100 High Performance Faux Fur Windshield
    USD $69.00
    Out of stock
    SKU: AZD-00059
    Model: SWS-100
    Condition: New-In-Box
  24. SWS-30 Furry Windshield Cover
    Azden Corporation SWS-30 Furry Windshield Cover
    USD $40.00
    Out of stock
    SKU: AZD-00001
    Model: SWS-30
    Condition: New-In-Box
  25. EX-507XD Professional Lapel Microphone For PRO-XD
    Azden Corporation EX-507XD Professional Lapel Microphone For PRO-XD
    USD $40.00
    Out of stock
    SKU: AZD-00005
    Model: EX-507XD
    Condition: New-In-Box
  26. SGM-990  Shotgun Microphone with Long and Short Pick-up Pattern
    SKU: AZD-00029A
    Model: SGM-990
    Condition: New-In-Box
View as Grid List

26 Items

per page
Set Ascending Direction