SELECT * FROM SpecsSubAssembly WHERE LAFD = 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 & COMPONENT SALES: 631-439-9220