|
|
SELECT Model, QtyOnHand as Delivery, FreqMinMHz, FreqMaxMHz, GainMindB, GainFlatnessdB, NoiseFiguredB, NoiseTemperatureK, InputVSWR, OutputVSWR, P1dBOutdBm,P1dBOutTypdBm, IP3OutdBm,IP3OutTypdBm, V1Nom, Curr1NommA,V2Nom, Curr2NommA,V3Nom, Curr3NommA, ImpedanceOhms, ConnectorIn, ConnectorOut, PartSpecificPDF, BipolarAmplifier,Detector, Cryogenic, DualOutput ,FiberOptic, GainControl,LowNoise,LimitingAmplifier,PowerMonitor,PulseAmplifier, PulseModulated,SATCOM,TemperatureCompensation,Package, LowPhaseNoise, LowCurrent, PN10Hz,PN1KHz,PN10KHz,PN1MHz,Wideband,Package, OutlineDrawing, Description FROM SpecsAmplifier WHERE TemperatureCompensation = 1 AND Model In (Select Model from ModelPrices where CatalogItem = 1 and CatalogDeptApproved = 1 and CatalogMKTApproved = 1 and Obsolete <> 1) ORDER BY (FreqMaxMHz-FreqMinMHz) Limit 0,50
|
|