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 '%2-24%' AND yaxley.TubeList LIKE '%27%' AND yaxley.TubeList LIKE '%35%' AND yaxley.TubeList LIKE '%47%' 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 '%2-24%' AND combinedtable.TubeList LIKE '%27%' AND combinedtable.TubeList LIKE '%35%' AND combinedtable.TubeList LIKE '%47%' 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 '%2-24%' AND redbook.TubeList LIKE '%27%' AND redbook.TubeList LIKE '%35%' AND redbook.TubeList LIKE '%47%' 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 |
---|---|---|---|---|---|---|---|
All-American Mohawk | S6 | 6 | 2-24, 35, 27, 47, 80 | Y | |||
Allied Radio Corporation | Knight | 264 (1932) | 6 | 2-24A, 27, 35/51, 47, 80 | S | ||
Audiola Radio Company | Audiola | 13S6 | 6 | 2-24, 27, 35, 47, 80 | Y | ||
Audiola Radio Company | Audiola | 6 Sh, 6 Jr | 6 | 2-24A, 27, 35/51, 47, 80 | S | ||
Belmont Radio Corporation | Belmont | 60 | 6 | 2-24A, 27, 35/51, 47, 80 | S | ||
Belmont Radio Corporation | Belmont | 60, 61, 62, 63, 64 | 6 | 2-24, 27, 35, 47, 80 | Y | ||
Cardinal Radio Manufacturing Company | Cardinal | 66 | 6 | 2-24A, 27, 35/51, 47, 80 | S | ||
Colonial Radio Corporation | Colonial | 44 | 6 | 2-24, 35, 47, 27, 80 | Y | ||
Colonial Radio Corporation | Colonial | 67E | 6 | 2-24A, 27, 35/51, 47, 80 | S | ||
DeWald Manufacturing Company | De Wald | B-A-G | 6 | 2-24, 27, 35, 47, 80 | Y | ||
DeWald Manufacturing Company | De Wald | BAG | 6 | 2-24A, 27, 35/51, 47, 80 | S | ||
Electrical Research Laboratories, Inc. | Erla, Sentinel | 61, 61P, 62, 63 | 6 | 2-24A, 27, 35/51, 47, 80 | S | ||
Electrical Research Laboratories, Inc. | Erla, Sentinel | 61, 62, 63 (250) | 6 | 2-24, 27, 35, 47, 80 | Y | ||
Federated Purchasers, Inc. | Acratone | S | 6 | 2-24A, 27, 35/51, 47, 80 | S | ||
Franklin Radio Corporation | Franklin | 103 | 6 | 2-24A, 27, 35/51, 47, 80 | S | ||
Franklin Radio Corporation | Franklin | 6 Tube | 6 | 27, 2-24, 35, 47, 80 | Y | ||
Franklin Radio Corporation | Franklin | 6 Tube Super | 6 | 2-24A, 27, 35/51, 47, 80 | S | ||
General Motors Radio Corporation | G-M | 211 (S9A, S9B) | 6 | 2-24, 35, 27, 47, 80 | Y | ||
General Motors Radio Corporation | G-M | 59A, 59B | 6 | 2-24A, 27, 35/51, 47, 80 | S | ||
Pilot Radio Corporation | Pilot | 1010 | 6 | 2-24A, 27, 35/51, 47, 80 | S |
Next | Last |