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 '%6d6%' AND yaxley.TubeList LIKE '%6a7%' AND yaxley.TubeList LIKE '%75%' AND yaxley.TubeList LIKE '%43%' 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 '%6d6%' AND combinedtable.TubeList LIKE '%6a7%' AND combinedtable.TubeList LIKE '%75%' AND combinedtable.TubeList LIKE '%43%' 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 '%6d6%' AND redbook.TubeList LIKE '%6a7%' AND redbook.TubeList LIKE '%75%' AND redbook.TubeList LIKE '%43%' 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 |
---|---|---|---|---|---|---|---|
Belmont Radio Corporation | Belmont | 530 | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
Capitol Radio Company | Capital | B-241 | 5 | 6A7, 6D6, 25Z5, 43, 75 | S | ||
Champion Radio Laboratories | Champion | 52 DWG | 5 | 6A7, 6D6, 25Z5, 43, 75 | S | ||
Champion Radio Laboratories | Champion | 52DWG | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
Climax Radio And Television, Inc. | Climax | 40, 41 | 5 | 6A7, 6D6, 25Z5, 43, 75 | L4953 | S | |
Climax Radio And Television, Inc. | Climax | 50, 56, 59 | 5 | 6A7, 6D6, 75, 43, 25Z5 | L55S2 | Y | |
Climax Radio And Television, Inc. | Climax | AH | 5 | 6A7, 6D6, 75, 43, 25Z5 | L49C | Y | |
Climax Radio And Television, Inc. | Climax | U-65 | 5 | 6A7, 6D6, 25Z5, 43, 75 | L49C | S | |
Climax Radio And Television, Inc. | Climax | US | 5 | 6A7, 6D6, 25Z5, 43, 75 | L49C | S | |
Clinton Manufacturing Company | Clinton | 146 | 5 | 6A7, 6D6, 25Z5, 43, 75 | K49C | S | |
Clinton Manufacturing Company | Clinton | 612SP | 5 | 6A7, 6D6, 75, 43, 25Z5 | L49B | Y | |
Clinton Manufacturing Company | Clinton | 615SQ | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
Clinton Manufacturing Company | Clinton | C62SQ | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
Commonwealth Radio Manufacturing Company | Commonwealth | 150 | 5 | 6A7, 6D6, 25Z5, 43, 75 | S | ||
Commonwealth Radio Manufacturing Company | Commonwealth | 150 | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
Continental Radio & Television Corporation | Admiral | B225, B227 | 5 | 6A7, 6D6, 25Z5, 43, 75 | L49B | S | |
Corona Radio And Television Corporation | Corona | 108 | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
Detrola Radio Corporation | Detrola | 109 | 5 | 1V, 6A7, 6D6, 43, 75 | S | ||
Detrola Radio Corporation | Detrola | 109 | 5 | 6A7, 6D6, 75, 43, 1V | Y | ||
Detrola Radio Corporation | Detrola | 116 | 5 | 6A7, 6D6, 25Z5, 43, 75 | S |
First | Previous | Next | Last |