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 '%80%' AND yaxley.TubeList LIKE '%6A7%' AND yaxley.TubeList LIKE '%6K7%' AND yaxley.TubeList LIKE '%6Q7%' AND yaxley.Num = '5' ) 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 '%80%' AND combinedtable.TubeList LIKE '%6A7%' AND combinedtable.TubeList LIKE '%6K7%' AND combinedtable.TubeList LIKE '%6Q7%' AND combinedtable.Num = '5' ) 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 '%80%' AND redbook.TubeList LIKE '%6A7%' AND redbook.TubeList LIKE '%6K7%' AND redbook.TubeList LIKE '%6Q7%' AND redbook.Num = '5' )
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 | 145A209, 148A256, 149A256 | 5 | 6A7, 6K7, 6Q7, 41, 80 | S | ||
Allied Radio Corporation | Knight | E10771, E10772 | 5 | 6A7, 6K7, 6Q7, 41, 80 | Y | ||
Allied Radio Corporation | Knight | E10795 | 5 | 6A7, 6K7, 6Q7, 41, 80 | Y | ||
Electrical Research Laboratories, Inc. | Erla, Sentinel | 148A | 5 | 6A7, 6K7, 6Q7, 41, 80 | S | ||
Electrical Research Laboratories, Inc. | Erla, Sentinel | 149A | 5 | 6A7, 6K7, 6Q7, 41, 80 | S | ||
Fada Radio & Electric Company | Fada, Fadalette | 54 | 5 | 6A7/6A8, 6K7, 6Q7, 6Y6, 80 | R | ||
Fada Radio & Electric Company | Fada, Fadalette | 554 | 5 | 6A7/6A8, 6K7, 6Q7, 6Y6, 80 | R | ||
Fada Radio & Electric Company | Fada, Fadalette | 554, 554U | 5 | 6A7, 6K7, 6Q7, 6Y6, 80 | S | ||
Fada Radio & Electric Company | Fada, Fadalette | 6A54 | 5 | 6A7/6A8, 6K7, 6Q7, 6Y6, 80 | R | ||
Garod Radio Corporation | Garod | 205, 205C, 205L, 205-1 | 5 | 6A7, 6K7, 6Q7, 42, 80 | Y | ||
Gilfillan Bros., Inc. | Gilfillan | 5S8, 558T | 5 | 6A7, 78, 75, 42, 80, or 6A8, 6K7, 6Q7, 6F6, 5W4 | Y | ||
Sentinel | See United Air Cleaner Corp | 148A | 5 | 6A7, 6K7, 6Q7, 41, 80 | Y | ||
Sentinel | See United Air Cleaner Corp | 148A | 5 | 6A7, 6K7, 6Q7, 41, 80 | R |