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 '%24%' AND yaxley.TubeList LIKE '%27%' AND yaxley.TubeList LIKE '%71%' AND yaxley.TubeList LIKE '%80%' 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 '%24%' AND combinedtable.TubeList LIKE '%27%' AND combinedtable.TubeList LIKE '%71%' AND combinedtable.TubeList LIKE '%80%' 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 '%24%' AND redbook.TubeList LIKE '%27%' AND redbook.TubeList LIKE '%71%' AND redbook.TubeList LIKE '%80%' 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 |
|---|---|---|---|---|---|---|---|
| Crosley Radio Corporation | Crosley | Buddy, Chum | 6 | 2-24, 2-71A, 27, 80 | Y | ||
| Crosley Radio Corporation | Crosley | Buddy, Chum | 6 | 2-24A, 27, 2-71A, 80 | S | ||
| Pilot Radio Corporation | Pilot | SG105 | 6 | 24, 2-27, 2-71, 80 | Y | ||
| Steinite Radio Manufacturing Company | Steinite | 10 Chassis No. 15 | 6 | 3-24A, 27, 71, 80 | Y | ||
| Steinite Radio Manufacturing Company | Steinite | 420 | Chen& No. 15 | 6 | 3-24A, 27, 71, 80 | Y | |
| Steinite Radio Manufacturing Company | Steinite | 42O, 450, (Chassis 15) | 6 | 3-24A, 27, 71A, 80 | S | ||
| Steinite Radio Manufacturing Company | Steinite | 450 | 15 | 6 | 3-24, 27, 71, 80 | Y |