Pro Audio & Engineering

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 (20458, 21232, 21437, 195971, 203064, 209473, 225657, 228533, 106107, 106108, 106109, 106110, 106112, 106113, 106353, 106505, 114981, 146516, 147416, 147417, 172020, 130410, 14032, 14033, 14034, 14035, 14036, 14037, 14038, 14039)) 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,20458,21232,21437,195971,203064,209473,225657,228533,106107,106108,106109,106110,106112,106113,106353,106505,114981,146516,147416,147417,172020,130410,14032,14033,14034,14035,14036,14037,14038,14039)
View as Grid List

Items 1-30 of 65

Page
per page
Set Ascending Direction
  1. SC1 TRRS Extension Cable
    Rode Microphones SC1 TRRS Extension Cable
    USD $25.00
    SKU: RODE-00258
    Model: SC1
    Condition: New-In-Box
  2. CL 1 Cable
    Sennheiser CL 1 Cable
    USD $20.97
    Out of stock
    SKU: SEN-00008
    Model: 005022
    Condition: New-In-Box
  3. VR-3EX AV Mixer
    Roland Systems Group VR-3EX AV Mixer
    USD $2,195.00
    Out of stock
    SKU: ROLA-00240
    Model: VR-3EX
    Condition: New-In-Box
  4. UL2S UltraLITE 2 Person Intercom System
    Eartec UL2S UltraLITE 2 Person Intercom System
    USD $335.00
    Out of stock
    SKU: EAR-000100
    Model: EAR-UL2S
    Condition: New-In-Box
  5. Connect Convert (HDMI to SDI)
    Atomos Connect Convert (HDMI to SDI)
    USD $99.00
    Out of stock
    SKU: ATO-1225
    Model: ATOMCCVHS1
    Condition: New-In-Box
  6. SC1.5XXJ Mic Cable Canare Star-Quad 3-Pin XLR Male to 3-Pin XLR Female (Black - 1.5 Foot)
    SKU: TEC-00025
    Model: SC1.5XXJ
    Condition: New-In-Box
  7. XLM-SPF XLR Male to 1/4 Phone Female
    Tecnec XLM-SPF XLR Male to 1/4 Phone Female
    USD $8.00
    Out of stock
    SKU: TEC-00610
    Model: XLM-SPF
    Condition: New-In-Box
  8. LIVETRAK L‑12
    Zoom LIVETRAK L‑12
    USD $649.99
    Out of stock
    SKU: ZOOM-05030
    Model: ZL12
    Condition: New-In-Box
  9. Scarlett Solo (2nd Generation)
    Focusrite Scarlett Solo (2nd Generation)
    USD $99.99
    Out of stock
    SKU: FCR-00100
    Model: AMS-SCARLETT-SOLO-2N
    Condition: New-In-Box
  10. Scarlett 2i2 (2nd Generation)
    Focusrite Scarlett 2i2 (2nd Generation)
    USD $149.99
    Out of stock
    SKU: FCR-00150
    Model: AMS-SCARLETT-2I2-2ND
    Condition: New-In-Box
  11. Scarlett 2i4 (2nd Generation)
    Focusrite Scarlett 2i4 (2nd Generation)
    USD $199.99
    Out of stock
    SKU: FCR-00110
    Model: AMS-SCARLETT-2I4-2ND-GEN
    Condition: New-In-Box
  12. iTrack Solo (Lightning)
    Focusrite iTrack Solo (Lightning)
    USD $119.99
    Out of stock
    SKU: FCR-00120
    Model: ITRACK-SOLO-LIGHTNING
    Condition: New-In-Box
  13. Clarett 4Pre
    Focusrite Clarett 4Pre
    USD $599.99
    Out of stock
    SKU: FCR-00140
    Model: AMS-CLARETT-4PRE
    Condition: New-In-Box
  14. Scarlett 18i8 (2nd Gen)
    Focusrite Scarlett 18i8 (2nd Gen)
    USD $349.99
    Out of stock
    SKU: FCR-00160
    Model: AMS-SCARLETT-18I8-2ND-GEN
    Condition: New-In-Box
  15. Saffire PRO 40
    Focusrite Saffire PRO 40
    USD $399.99
    Out of stock
    SKU: FCR-00170
    Model: AMS-SAFFIRE-PRO-40
    Condition: New-In-Box
  16. SE215-K Earphones, Shure PGA48 Cardioid Mic, and Focusrite Scarlet Solo 2nd Generation Bundle
    SKU: 31617
    Model: SE215-K, PGA 48-XLR, AMS-SCARLETT-SOLO-2N
    Condition: New-In-Box
  17. VR-4HD HD AV Mixer
    Roland Systems Group VR-4HD HD AV Mixer
    USD $2,795.00
    Out of stock
    SKU: ROLA-00105
    Model: VR-4HD
    Condition: New-In-Box
  18. Scarlett 2i2 Studio Pack (2nd Gen)
    Focusrite Scarlett 2i2 Studio Pack (2nd Gen)
    USD $249.99
    Out of stock
    SKU: FCR-00155
    Model: AMS-SCARLETT2I2STUDI
    Condition: New-In-Box
  19. Complete Studio Kit
    Rode Microphones Complete Studio Kit
    USD $349.00
    Out of stock
    SKU: RODE-00395
    Model: THECOMPLETESTUDIOKIT
    Condition: New-In-Box
  20. AI-1 USB AUDIO INTERFACE
    Rode Microphones AI-1 USB AUDIO INTERFACE
    USD $129.00
    Out of stock
    SKU: RODE-00396
    Model: AI1
    Condition: New-In-Box
  21. Mini Converter - SDI to Audio
    Blackmagic Design Mini Converter - SDI to Audio
    USD $215.00
    Out of stock
    SKU: BLM-00580
    Model: BMD-CONVMCSAUD
    Condition: New-In-Box
  22. DR-70D Portable Recorder
    Tascam DR-70D Portable Recorder
    USD $299.99
    Out of stock
    SKU: TAS-02510
    Model: DR-70D
    Condition: New-In-Box
  23. INS-26S 26' Premium Retractable Cable System
    Stage Ninja INS-26S 26' Premium Retractable Cable System
    USD $49.99
    Out of stock
    SKU: STA-00110
    Model: INS-26S
    Condition: New-In-Box
  24. 26' Premium Retractable XLR Cable System with Female Neutrik NC3-
    SKU: STA-00120
    Model: XLR-26S
    Condition: New-In-Box
  25. 26' Premium Retractable XLR Cable System with Male Retractable En
    SKU: STA-00130
    Model: XLR-26D
    Condition: New-In-Box
  26. 60' Premium Retractable XLR Cable Female Neutrik NC3-XX on Retrac
    SKU: STA-00210
    Model: XLR-60S
    Condition: New-In-Box
  27. 60' Premium Retractable XLR Cable with Male Retractable End
    SKU: STA-00220
    Model: XLR-60D
    Condition: New-In-Box
  28. 40' Retractable Speaker Cable System with Speakon NL2FC Connector
    SKU: STA-00310
    Model: SPK-40SP
    Condition: New-In-Box
  29. 40' Retractable Speaker Cable System with 1/4” to 1/4” Neutrik Co
    SKU: STA-00320
    Model: SPK-40QI
    Condition: New-In-Box
  30. 58' Retractable Speaker Cable System with Speakon NL2FC Connector
    SKU: STA-00330
    Model: SPK-58SP
    Condition: New-In-Box
View as Grid List

Items 1-30 of 65

Page
per page
Set Ascending Direction