Mixers & Boards

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 (13545, 13546, 13674, 462615, 367157, 522918, 525663, 525666, 518649, 228533, 21437, 106107, 106108, 106109, 106110, 106112, 106113, 106353, 106505, 114981, 130410)) 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,13545,13546,13674,462615,367157,522918,525663,525666,518649,228533,21437,106107,106108,106109,106110,106112,106113,106353,106505,114981,130410)
View as Grid List

21 Items

per page
Set Ascending Direction
  1. VR-3 A/V Mixer
    Roland Systems Group VR-3 A/V Mixer
    USD $1,995.00
    Out of stock
    SKU: ROLA-00100
    Model: VR-3
    Condition: New-In-Box
  2. VR-5 A/V Mixer and Recorder
    Roland Systems Group VR-5 A/V Mixer and Recorder
    USD $4,995.00
    Out of stock
    SKU: ROLA-00110
    Model: VR-5
    Condition: New-In-Box
  3. R-44-R Compact Four-Channel Portable Recorder
    Roland Systems Group R-44-R Compact Four-Channel Portable Recorder
    USD $1,095.00
    Out of stock
    SKU: ROLA-00210
    Model: R-44-R
    Condition: New-In-Box
  4. RODECaster Pro II
    Rode Microphones RODECaster Pro II
    USD $699.00
    SKU: RODE-00291
    Model: RCP2
    Condition: New-In-Box
  5. UA844+SWB Antenna Distribution System
    Shure UA844+SWB Antenna Distribution System
    USD $569.00
    Out of stock
    SKU: SHU-00267
    Model: UA844+SWB
    Condition: New-In-Box
  6. UAC-232 USB Audio Converter
    Zoom UAC-232 USB Audio Converter
    USD $199.99
    Out of stock
    SKU: ZOOM-UAC-232
    Model: ZUAC232
    Condition: New-In-Box
  7. ATEM Television Studio HD8
    Blackmagic Design ATEM Television Studio HD8
    USD $2,995.00
    Out of stock
    SKU: BMD-01001
    Model: BMD-SWATEMTVSTA/HD08
    Condition: New-In-Box
  8. ATEM Television Studio HD8 ISO
    Blackmagic Design ATEM Television Studio HD8 ISO
    USD $3,995.00
    Out of stock
    SKU: BMD-01002
    Model: BMD-SWATEMTVSTC/HD08ISO
    Condition: New-In-Box
  9. AX1 Miniature 2-Channel 3.5mm Microphone & Audio Mixer
    SKU: SAR-01013
    Model: AX1
    Condition: New-In-Box
  10. LIVETRAK L‑12
    Zoom LIVETRAK L‑12
    USD $649.99
    Out of stock
    SKU: ZOOM-05030
    Model: ZL12
    Condition: New-In-Box
  11. 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
  12. 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
  13. 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
  14. 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
  15. iTrack Solo (Lightning)
    Focusrite iTrack Solo (Lightning)
    USD $119.99
    Out of stock
    SKU: FCR-00120
    Model: ITRACK-SOLO-LIGHTNING
    Condition: New-In-Box
  16. Clarett 4Pre
    Focusrite Clarett 4Pre
    USD $599.99
    Out of stock
    SKU: FCR-00140
    Model: AMS-CLARETT-4PRE
    Condition: New-In-Box
  17. 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
  18. 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
  19. 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
  20. 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
  21. 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
View as Grid List

21 Items

per page
Set Ascending Direction