SELECT * FROM SpecsEqualizer WHERE Channels > 1 AND Model In (Select Model from ModelPrices where CatalogItem = 1 and CatalogDeptApproved = 1 and CatalogMKTApproved = 1 and Obsolete <> 1) ORDER BY Model Limit 0,50
For further information, pricing, and delivery please contact SATCOM SALES: 631-439-9108