SELECT Model, BandIn, InputFreqMinMHz,InputFreqMaxMHz,BandOut,OutputFreqMinMHz,OutputFreqMaxMHz,StepSizeKHz,DownConverter,UpConverter,BlockConverter,SynthesizedTunable,Indoor,Outdoor,NumBands,NumChannels,AutoFreqControl,Description,PartSpecificPDF FROM SpecsConverter WHERE ((BandIn = 'C') OR (BandOut = 'C')) ORDER BY Model LIMIT 0,50