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 '%25z5%' AND yaxley.TubeList LIKE '%43%' AND yaxley.TubeList LIKE '%6d6%' AND yaxley.TubeList LIKE '%6c6%' AND yaxley.Num = '4' ) 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 '%25z5%' AND combinedtable.TubeList LIKE '%43%' AND combinedtable.TubeList LIKE '%6d6%' AND combinedtable.TubeList LIKE '%6c6%' AND combinedtable.Num = '4' ) 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 '%25z5%' AND redbook.TubeList LIKE '%43%' AND redbook.TubeList LIKE '%6d6%' AND redbook.TubeList LIKE '%6c6%' AND redbook.Num = '4' )
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 | 15A1 | 4 | 6C6, 6D6, 25Z5, 43 | L49C | S | |
Allied Radio Corporation | Knight | 30MC5 | 4 | 6C6, 6D6, 25Z5, 43 | L49C | S | |
Allied Radio Corporation | Knight | 30N3, 31-W9 | 4 | 6C6, 6D6, 25Z5, 43 | L55B | S | |
Allied Radio Corporation | Knight | 4052 | 4 | 6C6, 6D6, 25Z5, 43 | S | ||
Allied Radio Corporation | Knight | 41-14, 41-15 | 4 | 6C6, 6D6, 25Z5, 43 | L49C | S | |
Allied Radio Corporation | Knight | 4215 | 4 | 6C6, 6D6, 25Z5, 43 | L49C | S | |
Allied Radio Corporation | Knight | 69UT, 69U147 | 4 | 6C6, 6D6, 25Z5, 43 | L55B | S | |
Allied Radio Corporation | Knight | A9701, A9702, A9703, A9704 | 4 | 6D6, 6C6, 43, 25Z5 | L49C | Y | |
Allied Radio Corporation | Knight | A9715, A9716, A9717, 49718 | 4 | 6D6, 6C6, 43, 25Z5 | L49C | Y | |
Allied Radio Corporation | Knight | A9825 | 4 | 6D6, 6C6, 43, 25Z5 | L55B | Y | |
Allied Radio Corporation | Knight | E10893 | 4 | 6D6, 6C6, 43, 25Z5 | Y | ||
Andrea Radio Corp. | 410 (UC4) | 4 | 6D6, 6C6, 43, 25Z5 | C4B | Y | ||
Andrea Radio Corp. | 411 (UC4L) | 4 | 6D6, 6C6, 43, 25Z5 | C4B | Y | ||
Autocrat Radio Company | Autocrat | 4-LW, 4-SA | 4 | 6C6, 6D6, 25Z5, 43 | S | ||
Autocrat Radio Company | Autocrat | 4LW | 4 | 6D6, 6C6, 43, 25Z5 | Y | ||
Autocrat Radio Company | Autocrat | 4SA | 4 | 6D6, 6C6, 43, 25Z5 | Y | ||
Autocrat Radio Company | Autocrat | 5-M, 61 | 4 | 6C6, 6D6, 25Z5, 43 | K55C | S | |
Autocrat Radio Company | Autocrat | 57, 575W, 58, 58-SW | 4 | 6C6, 6D6, 25Z5, 43 | K55C | S | |
Autocrat Radio Company | Autocrat | 5C, 52, 52-SW, 53, 53-SW, 56-SW, 34B | 4 | 6C6, 6D6, 25Z5, 43, 50A2 | K55C | S | |
Autocrat Radio Company | Autocrat | 5M | 4 | 6D6, 6C6, 43, 25Z5 | L55B | Y |
First | Previous | Next | Last |