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 |
|---|---|---|---|---|---|---|---|
| Allied Radio Corporation | Knight | 60BX44 | 5 | 6A7, 6D6, 25Z5, 43, 75 | 50A2 | S | |
| Allied Radio Corporation | Knight | 61-88 | 5 | 6A7, 6D6, 25Z5, 43, 75 | L49C | S | |
| Allied Radio Corporation | Knight | A60B | 5 | 6A7, 6D6, 25Z5, 43, 75 | S | ||
| Allied Radio Corporation | Knight | A9851 | B-2 | 5 | 6A7, 6D6, 75, 43, 25Z5 | L49B | Y |
| Allied Radio Corporation | Knight | B227 | 5 | 6A7, 6D6, 25Z5, 43, 75 | 49B | S | |
| Allied Radio Corporation | Knight | G9553 | 5 | 6A7, 6D6, 25Z5, 43, 75 | Y | ||
| Allied Radio Corporation | Knight | G9557 | 5 | 6A7, 6D6, 25Z5, 43, 75 | Y | ||
| Allied Radio Corporation | Knight | UE | 5 | 6A7, 6D6, 25Z5, 43, 75 | S | ||
| Andrea Radio Corp. | 520 (UD5S), 521 (UD5L) | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | |||
| Andrea Radio Corp. | 62PX (PXD5) | 5 | 6A7, 6D6, 75, 43, 25Z6 | Y | |||
| Andrea Radio Corp. | 62X (XD5) | 5 | 6A7, 6D6, 75, 43, 25Z6 | Y | |||
| Audiola Radio Company | Audiola | 34-C | 5 | 6A7, 6D6, 12Z3, 43, 75 | S | ||
| Audiola Radio Company | Audiola | 34C5 (AC-DC) | 5 | 6A7, 6D6, 75, 43, 12Z3 | Y | ||
| Autocrat Radio Company | Autocrat | 5-SA | 5 | 6A7, 6D6, 25Z5, 43, 75 | S | ||
| Autocrat Radio Company | Autocrat | 5SA (55SA) | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Automatic Radio Manufacturing Co. | Automatic, Tom Thumb | 56 | 5 | 6A7, 6D6, 25Z5, 43, 75 | K49C | S | |
| Automatic Radio Manufacturing Co. | Automatic, Tom Thumb | B30 Series I | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Automatic Radio Manufacturing Co. | Automatic, Tom Thumb | S6 | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Balkeit Radio Company | Balkeit | 59 | 5 | 6A7, 6D6, 25Z5, 43, 75 | S | ||
| Belmont Radio Corporation | Belmont | 53 | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y |
| First | Previous | Next | Last |