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 |
|---|---|---|---|---|---|---|---|
| Spiegel, Incorporated | Aircastle | 5258 | 5 | 6A7, 6D6, 25Z5, 43, 75 | S | ||
| Spiegel, Incorporated | Aircastle | 58S | 5 | 6A7, 6D6, 25Z5, 43, 75 | S | ||
| Stewart-Warner Corporation | Stewart-Warner | R171 | 5 | 6A7, 6D6, 25Z5, 43, 75 | S | ||
| Stewart-Warner Corporation | Stewart-Warner | R171 (1711 to 1719) | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Stewart-Warner Corporation | Stewart-Warner | R188 (1881 to 1889) | 5 | 6A7, 6D6, 75, 43, 25Z5 | M49B | Y | |
| Transformer Corporation Of America | Clarion | TC36A, TC36LW | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Trav-Ler Radio & Telev. Corporation | Trav-Ler | 550 | 5 | 6A7, 6D6, 25Z5, 43, 75 | S | ||
| Trav-Ler Radio & Telev. Corporation | Trav-Ler | 60A | 5 | 6A7, 6D6, 25Z5, 43, 75 | S | ||
| Trav-Ler Radio & Telev. Corporation | Trav-Ler | 60A | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Trav-Ler Radio & Telev. Corporation | Trav-Ler | 622, 623 | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Trav-Ler Radio & Telev. Corporation | Trav-Ler | 622, 623, 626 | 5 | 6A7, 6D6, 25Z5, 43, 75 | 165R8 | S | |
| Trav-Ler Radio & Telev. Corporation | Trav-Ler | 626, 627 | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Trav-Ler Radio & Telev. Corporation | Trav-Ler | 627 | 5 | 6A7, 6D6, 25Z5, 43, 75 | K48BK4 | S | |
| Troy Radio & Television Company | Troy | 151-5 | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Troy Radio & Television Company | Troy | 175 | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Troy Radio & Television Company | Troy | 175 | 5 | 6A7, 6D6, 25Z5, 43, 75 | S | ||
| United American Bosch Corporation | American Bosch, Bosch | 05 | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| United American Bosch Corporation | American Bosch, Bosch | 610, 610A | 5 | 6A7, 6D6, 75, 43, 25Z5 | K49C | Y | |
| Walgreen | 300, 300P Early | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | |||
| Walgreen | 300P Late | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y |
| First | Previous | Next | Last |