SELECT Model, BandIn, InputFreqMinMHz, InputFreqMaxMHz, BandOut, OutputFreqMinMHz, OutputFreqMaxMHz, LOFreqMHz, Indoor, Outdoor, TestTranslator, NumBands, Description, Delivery, Package, PartSpecificPDF FROM SpecsTranslator WHERE ((BandIn = 'X') OR (BandOut = 'X')) 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