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 '%2-24%' AND yaxley.TubeList LIKE '%27%' AND yaxley.TubeList LIKE '%35%' AND yaxley.TubeList LIKE '%47%' AND yaxley.Num = '6' ) 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 '%2-24%' AND combinedtable.TubeList LIKE '%27%' AND combinedtable.TubeList LIKE '%35%' AND combinedtable.TubeList LIKE '%47%' AND combinedtable.Num = '6' ) 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 '%2-24%' AND redbook.TubeList LIKE '%27%' AND redbook.TubeList LIKE '%35%' AND redbook.TubeList LIKE '%47%' AND redbook.Num = '6' )
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 |
---|---|---|---|---|---|---|---|
Pilot Radio Corporation | Pilot | 1010 All Wave Dragon | 6 | 2-24A, 27, 35, 47, 80 | Y | ||
Remler Company, Ltd. | Remler, Scottie | 10 | 6 | 35, 2-24A, 27, 47, 80 | Y | ||
Remler Company, Ltd. | Remler, Scottie | 10, 10-11 | 6 | 2-24A, 27, 35/51, 47, 80 | S | ||
Rudolph Wurlitzer Mfg. Company | S-6, S-61, S-62 | 6 | 2-24A, 27, 35/51, 47, 80 | S | |||
Sears, Roebuck & Company | Silvertone | 1390, 1400, 1402, 1404, 1406 | 6 | 2-24A, 27, 35/51, 47, 80 | S | ||
Sears, Roebuck & Company | Silvertone | 1390, 1400, 1402, 1404, 1406 (101) | 6 | 2-24A, 35, 47, 27, 80 | Y | ||
Sears, Roebuck & Company | Silvertone | 1470 (101) | 6 | 2-24A, 35, 47, 27, 80 | Y | ||
Sears, Roebuck & Company | Silvertone | 7009 (101) | 6 | 2-24, 35, 47, 27, 80 | Y | ||
Silver-Marshall Manufacturing Company | Silver-Marshall | B | 6 | 2-24A, 27, 35, 47, 80 | Y | ||
Silver-Marshall Manufacturing Company | Silver-Marshall | B | 6 | 2-24A, 27, 35/51, 47, 80 | S | ||
Stewart-Warner Corporation | Stewart-Warner | R102A, B, and E | 6 | 2-24A, 51 or 35, 47, 27, 80 | Y | ||
Stewart-Warner Corporation | Stewart-Warner | R102A, B, E, AC | 6 | 2-24A, 27, 35/51, 47, 80 | S |
First | Previous |