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 '%4-27%' AND yaxley.TubeList LIKE '%3-35%' AND yaxley.TubeList LIKE '%2-47%' AND yaxley.TubeList LIKE '%80%' AND yaxley.Num = '10' ) 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 '%4-27%' AND combinedtable.TubeList LIKE '%3-35%' AND combinedtable.TubeList LIKE '%2-47%' AND combinedtable.TubeList LIKE '%80%' AND combinedtable.Num = '10' ) 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 '%4-27%' AND redbook.TubeList LIKE '%3-35%' AND redbook.TubeList LIKE '%2-47%' AND redbook.TubeList LIKE '%80%' AND redbook.Num = '10' )
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 |
|---|---|---|---|---|---|---|---|
| Gamble Skogmo, Inc. | Coronado | 70 | 10 | 3-35, 4-27, 2-47, 80 | Y | ||
| Grebe Manufacturing Company, Inc. | Grebe | HS6 | 10 | 4-27, 3-35/51, 2-47, 80 | S | ||
| Herbert H. Horn | Tiffany Tone | 110 | 10 | 4-27, 3-35, 2-47, 80 | Y | ||
| Kennedy Corporation, Colin B. | 62A | 10 | 4-27, 3-35/51, 2-47, 80 | S | |||
| Montgomery Ward And Company | Airline | 1 | 10 | 4-27, 3-35/51, 2-47, 80 | S | ||
| Montgomery Ward And Company | Airline | 1355 | 10 | 4-27, 3-35/51, 2-47, 80 | S | ||
| Montgomery Ward And Company | Airline | 1955 | 10 | 4-27, 3-35/51, 2-47, 80 | S | ||
| Montgomery Ward And Company | Airline | 28 | 10 | 4-27, 3-35/51, 2-47, 80 | S | ||
| Montgomery Ward And Company | Airline | 62-1, 62-2 | 10 | 4-27, 3-35, 2-47, 80 | Y | ||
| Radiotrope | 70-R | 10 | 4-27, 3-35/51, 2-47, 80 | S | |||
| Radiotrope | 70R | 10 | 3-35, 4-27, 2-47, 80 | Y | |||
| Sears, Roebuck & Company | Silvertone | 7003 | 10 | 4-27, 3-35/51, 2-47, 80 | S | ||
| Sonora Radio Manufacturing Corporation | Sonora | 71, 72, 73 | 10 | 4-27, 3-35, 2-47, 80 | Y | ||
| Story And Clark Radio Corporation | Story And Clark | 75 | 10 | 4-27, 3-35/51, 2-47, 80 | S | ||
| Templetone Radio Corporation | Temple | 170, 171 | 10 | 4-27, 3-35/51, 2-47, 80 | S | ||
| Transformer Corporation Of America | Clarion | 25-160 | 10 | 4-27, 3-35/51, 2-47, 80 | S | ||
| Transformer Corporation Of America | Clarion | AC-160 | 10 | 4-27, 3-35/51, 2-47, 80 | S | ||
| U. S. Radio And Television Corporation | Apex | 10 | 10 | 3-35, 4-27, 2-47, 80 | Y | ||
| U. S. Radio And Television Corporation | Apex | 10B, 200 | 10 | 4-27, 3-35/51, 2-47, 80 | S | ||
| U. S. Radio And Television Corporation | Apex | 10C | 1000-1001 | 10 | 3-35, 4-27, 2-47, 80 | Y |