Cables, Patches, & Accessories

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 (336529, 336530, 336531, 518743, 518744, 292567, 195971, 203064, 209473, 225657, 525669)) 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,336529,336530,336531,518743,518744,292567,195971,203064,209473,225657,525669)
View as Grid List

Items 31-41 of 41

Page
per page
Set Ascending Direction
  1. Audio Cable 3.5mm TRRS Male Straight to Dual 3.5mm Female Straight (7 1/2" Straight Splitter)
    SKU: PRO-20906
    Model: 8067
    Condition: New-In-Box
  2. USB-C male straight to 3.5mm TRS male right angle Audio Cable (8 1/2" coiled)
    SKU: PRO-20907
    Model: 9047
    Condition: New-In-Box
  3. Audio Adapter Cable USB-C Male Straight to 3.5mm TRRS Female Straight (3" Straight)
    SKU: PRO-20908
    Model: 9054
    Condition: New-In-Box
  4. SR-EA2D Lightning Audio Interface w/ 3.5mm TRS / TRRS
    SKU: SAR-01024
    Model: SR-EA2D
    Condition: New-In-Box
  5. SR-EA2U USB-C Audio Interface w/ 3.5mm TRS / TRRS
    SKU: SAR-01025
    Model: SR-EA2U
    Condition: New-In-Box
  6. 8. 2' (2.5m) Microphone, Headphones & Audio Extension Cable With 3.5mm Trrs Female To Male Connectors
    SKU: SAR-00393
    Model: SR-SC2500
    Condition: New-In-Box
  7. 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
  8. 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
  9. 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
  10. 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
  11. ATEM Microphone Converter
    Blackmagic Design ATEM Microphone Converter
    USD $395.00
    Out of stock
    SKU: BMD-01003
    Model: BMD-SWATEMTVSTDMC
    Condition: New-In-Box
View as Grid List

Items 31-41 of 41

Page
per page
Set Ascending Direction