|
|
SELECT * FROM SpecsSubAssembly WHERE Amplifier = 1 AND Switch = 1 AND FilterBank = 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
|
|