Contact Sales l Support l or Call us today at (866) 446-3595 Remote Technical Support

Products

Compare up to 4 models
Sort By:
Showing: 1 - 8 of 8 Matching
Filter Your Results

HD over Coax/IP

Operating System

Type

DW-ACS
ACS for MAC
Add to quote builder
DW-ACS-VMAX-AHD-Core
ACS VMAX AHD Core™ for MAC
Add to quote builder
DW-ACS-VMAXIP-Plus
ACS VMAX IP Plus™ for MAC
Add to quote builder
DW Spectrum Mobile (for v2.5 and Higher)
DW Spectrum Mobile
Add to quote builder
DW VMAX App
Add to quote builder
DW® Mobile
DW® Mobile & DW Mobile Pro
Add to quote builder
Pivot Pro
Pivot Pro™ Remote Client Software
Add to quote builder
DW-PIVOT HYBRID CMS
Pivot Central Monitoring Software
Add to quote builder

SELECT p.*, a.attribute_id, IFNULL(a.attribute_name,' ') as resolution, CASE WHEN p.product_comingsoon = 1 THEN 1 WHEN p.product_new = 1 THEN 2 WHEN p.product_clearance = 1 THEN 4 WHEN p.product_discontinued = 1 THEN 5 WHEN p.product_outofstock = 1 THEN 6 ELSE 3 END AS sort FROM products as p left join m_product_attribute m ON m.product_id = p.product_id and m.attribute_id in (select attribute_id from attribute where attribute_type_id = 489) left join attribute a on m.attribute_id = a.attribute_id inner join ( m_product_attribute as map0, attribute as arr0) on ( map0.product_id = p.product_id and arr0.attribute_id = map0.attribute_id AND ( arr0.attribute_name="Software" ) ) inner join ( m_product_attribute as map1, attribute as arr1) on ( map1.product_id = p.product_id and arr1.attribute_id = map1.attribute_id AND ( arr1.attribute_name="Analog" ) ) WHERE p.product_status = 1 AND show_product_list = 1 AND show_on_outlet_store = 0 and product_discontinued <> 1 group by p.product_id ORDER BY sort, p.product_order, resolution DESC, p.product_name ASC

Sort By:
Showing: 1 - 8 of 8 Matching