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 '%6a7%' AND yaxley.TubeList LIKE '%6c6%' 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 '%25z5%' AND combinedtable.TubeList LIKE '%6a7%' AND combinedtable.TubeList LIKE '%6c6%' 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 '%25z5%' AND redbook.TubeList LIKE '%6a7%' AND redbook.TubeList LIKE '%6c6%' 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 |
---|---|---|---|---|---|---|---|
Air King Products Company, Inc. | Air King | 250 | 5 | 6A7, 6D6, 6C6, 43, 25Z5 | Y | ||
Air King Products Company, Inc. | Air King | 250 | 5 | 6A7, 6C6, 6D6, 25Z5, 43 | S | ||
Air King Products Company, Inc. | Air King | 710 | 5 | 6A7, 6D6, 6C6, 43, 25Z5 | M49HG | Y | |
Air King Products Company, Inc. | Air King | 710, 715, 720 | 5 | 6A7, 6C6, 6D6, 25Z5, 43 | M49HG | S | |
Air King Products Company, Inc. | Air King | 715 | 5 | 6A7, 6D6, 6C6, 43, 25Z5 | M49HG | Y | |
Ansley Radio Corporation | Ansley Dynaphone | D7 | 5 | 6A7, 6C6, 6D6, 25Z5, 43 | S | ||
Edison-Bell Company, Inc. | Edison-Bell | 53-LW | 5 | 6A7, 6C6, 6D6, 25Z5, 43 | S | ||
Edison-Bell Company, Inc. | Edison-Bell | 53LW | 5 | 6A7, 6D6, 6C6, 43, 25Z5 | Y | ||
Espey Manufacturing Co., Inc. | Espey | 556 | 5 | 6A7, 6C6, 6D6, 25Z5, 43 | S | ||
F. A. D. Andrea, Inc. | Andrea | 130L | 5 | 6A7, 6D6, 6C6, 43, 25Z5 | Y | ||
Federated Purchasers, Inc. | Acratone | 121 | 5 | 6A7, 6C6, 6D6, 25Z5, 43 | S | ||
Federated Purchasers, Inc. | Acratone | 121 | 5 | 6A7, 6D6, 6C6, 43, 25Z5 | Y | ||
Halson Radio Manufacturlng Corp. | Halson | 535 | 5 | 6A7, 6C6, 6D6, 25Z5, 43 | S | ||
Halson Radio Manufacturlng Corp. | Halson | 535 | 5 | 6A7, 6D6, 6C6, 43, 25Z5 | Y | ||
Halson Radio Manufacturlng Corp. | Halson | 55 LW | 5 | 6A7, 6C6, 6D6, 25Z5, 43 | S | ||
Lang Radio Company | Lang | 503US | 5 | 6A7, 6D6, 6C6, 43, 25Z5 | Y | ||
Lehman Radio Salon, Inc. | Port-O-Matic | 12 LW | 5 | 6A7, 6C6, 6D6, 25Z5, 43 | S |