combined query = (SELECT companies.Company AS company2, companies.Tradename AS tradename, yaxley.Num, yaxley.Model AS Model2, yaxley.TubeList, yaxley.Resistor, yaxley.YSLR, yaxley.chassis FROM companies, yaxley WHERE yaxley.Company_ID = companies.Company_ID AND yaxley.TubeList LIKE '%6a7%' AND yaxley.TubeList LIKE '%6k7%' AND yaxley.TubeList LIKE '%6f5%' AND yaxley.TubeList LIKE '%6h6%' AND yaxley.Num = '6' ) UNION (SELECT companies.Company AS company2, companies.Tradename AS tradename, combinedtable.Num, combinedtable.Model AS Model2, combinedtable.TubeList, combinedtable.Resistor, combinedtable.YSLR, combinedtable.chassis FROM companies, combinedtable WHERE combinedtable.Company_ID = companies.Company_ID AND combinedtable.YSLR LIKE 'S' AND combinedtable.TubeList LIKE '%6a7%' AND combinedtable.TubeList LIKE '%6k7%' AND combinedtable.TubeList LIKE '%6f5%' AND combinedtable.TubeList LIKE '%6h6%' AND combinedtable.Num = '6' ) UNION (SELECT companies.Company AS company2, companies.Tradename AS tradename, redbook.Num, redbook.Model AS Model2, redbook.TubeList, redbook.Resistor, redbook.YSLR, redbook.chassis FROM companies, redbook WHERE redbook.Company_ID = companies.Company_ID AND redbook.TubeList LIKE '%6a7%' AND redbook.TubeList LIKE '%6k7%' AND redbook.TubeList LIKE '%6f5%' AND redbook.TubeList LIKE '%6h6%' AND redbook.Num = '6' )
Type in any known information. At least one field needs to be entered or nothing will be shown.
Additional instructions and background info can be found here.
Company | Tradename | Model | Chassis | # Tubes | Tube List | Ballast | Database |
---|---|---|---|---|---|---|---|
Allied Radio Corporation | Knight | ML2 | 6 | 6A7, 6F5, 6F6, 6H6, 6K7, 80 | S | ||
Allied Radio Corporation | Knight | ML215A | 6 | 6A7, 6F5, 6F6, 6H6, 6K7, 80 | S | ||
Andrea Radio Corp. | 1B6 (B6L) | 6 | 6A7, 6K7, 6H6, 6F5, 42, 80 | Y | |||
Andrea Radio Corp. | 2B6 (B6S) | 6 | 6A7, 6K7, 6H6, 6F5, 42, 80 | Y | |||
Andrea Radio Corp. | 3B6 (B6L) | 6 | 6A7, 6K7, 6H6, 6F5, 42, 80 | Y | |||
Andrea Radio Corp. | 4B6 (B6S) | 6 | 6A7, 6K7, 6H6, 6F5, 42, 80 | Y | |||
Balkeit Radio Company | Balkeit | G16A, G19B | 6 | 6A7, 6K7, 6H6, 6F5, 6F6, 80 | Y | ||
Balkeit Radio Company | Balkeit | GT-18, GT-19B | 6 | 6A7, 6F5, 6F6, 6H6,-6K7, 80 | S | ||
Balkeit Radio Company | Balkeit | ML1, ML2 | 6 | 6A7, 6K7, 6H6, 6F5, 6F6, 80 | Y | ||
Continental Radio & Television Corporation | Admiral | L2 | 6 | 6A7, 6K7, 6H6, 6F5, 6F6, 80 | Y | ||
Continental Radio & Television Corporation | Admiral | L266 | 6 | 6A7, 6F5, 6F6, 6H6, 6K7, 80 | S | ||
Continental Radio & Television Corporation | Admiral | ML156, ML266 | 6 | 6A7, 6K7, 6H6, 6F5, 6F6, 80 | Y | ||
Continental Radio & Television Corporation | Admiral | MLl 56, ML215A, ML266, ML366 | 6 | 6A7, 6F5, 6F6, 6H6, 6K7, 80 | S | ||
Emerson.Radio & Phono. Corporation | Emerson | 107 (U6F) | 6 | 6A7, 6K7, 6H6, 6F5, 43, 25Z5 | Y | ||
Emerson.Radio & Phono. Corporation | Emerson | 107, 111-U6F, 107, 111 LW | 6 | 6A7, 6F5, 6H6, 6K7, 25Z5, 43 | S | ||
Emerson.Radio & Phono. Corporation | Emerson | 107LW (U6C) | 6 | 6A7, 6K7, 6H6, 6F5, 43, 25Z5 | Y | ||
Emerson.Radio & Phono. Corporation | Emerson | 111 (U6F) | 6 | 6A7, 6K7, 6H6, 6F5, 43, 25Z5 | Y | ||
Emerson.Radio & Phono. Corporation | Emerson | 111LW (U6C) | 6 | 6A7, 6K7, 6H6, 6F5, 43, 25Z5 | Y | ||
Fada Radio & Electric Company | Fada, Fadalette | 1B6, 2B6, 3B6, 4B6 | 6 | 6A7, 6F5, 6H6, 6K7, 42, 80 | S | ||
Garod Radio Corporation | Garod | 26 | 6 | 6A7, 6F5, 6F6, 6H6, 6K7, 80 | S |
Next | Last |