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 '%6A7%' AND yaxley.TubeList LIKE '%6d6%' AND yaxley.TubeList LIKE '%6q7%' AND yaxley.TubeList LIKE '%25l6%' AND (companies.Company LIKE '%Emerso%' OR companies.tradename LIKE '%Emerso%') 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 '%6A7%' AND combinedtable.TubeList LIKE '%6d6%' AND combinedtable.TubeList LIKE '%6q7%' AND combinedtable.TubeList LIKE '%25l6%' AND (companies.Company LIKE '%Emerso%' OR companies.tradename LIKE '%Emerso%') 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 '%6A7%' AND redbook.TubeList LIKE '%6d6%' AND redbook.TubeList LIKE '%6q7%' AND redbook.TubeList LIKE '%25l6%' AND (companies.Company LIKE '%Emerso%' OR companies.tradename LIKE '%Emerso%') 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 |
---|---|---|---|---|---|---|---|
Emerson.Radio & Phono. Corporation | Emerson | AA-131, 191, 204, 207 | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | L49B | S | |
Emerson.Radio & Phono. Corporation | Emerson | AA131 | AA above 1,266,501 | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | Y | |
Emerson.Radio & Phono. Corporation | Emerson | AD-108 | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | S | ||
Emerson.Radio & Phono. Corporation | Emerson | AD108 | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | Y | ||
Emerson.Radio & Phono. Corporation | Emerson | AD110 | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | Y | ||
Emerson.Radio & Phono. Corporation | Emerson | AD125 | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | Y | ||
Emerson.Radio & Phono. Corporation | Emerson | AE-107 | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | S | ||
Emerson.Radio & Phono. Corporation | Emerson | AE163 | AE | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | Y | |
Emerson.Radio & Phono. Corporation | Emerson | AH-162 | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | L49B | S | |
Emerson.Radio & Phono. Corporation | Emerson | AH162 (A11) | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | Y | ||
Emerson.Radio & Phono. Corporation | Emerson | AH166 | AH | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | L49B | R |
Emerson.Radio & Phono. Corporation | Emerson | AH166, 171, 173, 174, 176, 180, 185 (AH) | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | L49BG | Y | |
Emerson.Radio & Phono. Corporation | Emerson | AH171, AH173, AH- 174, AHI76, AH180, AH185 | AH | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | L49BG | R |
Emerson.Radio & Phono. Corporation | Emerson | AH171, AH173, AH174, AH176, AH180,AH185 | AH | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | L49DG | R |
Emerson.Radio & Phono. Corporation | Emerson | AL-130, 132, 202 | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | S | ||
Emerson.Radio & Phono. Corporation | Emerson | AL-149, 164, 168, AM-131, 169, 187 L.W. | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | 2UR-224 | S | |
Emerson.Radio & Phono. Corporation | Emerson | AL130, A1,132, AL149 | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | Y | ||
Emerson.Radio & Phono. Corporation | Emerson | AL168 | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | Y | ||
Emerson.Radio & Phono. Corporation | Emerson | AL202 | AL | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | L49B | R |
Emerson.Radio & Phono. Corporation | Emerson | AL202 (AL) | 5 | 6A7, 6D6, 6Q7, 25L6, 25Z5 | Y |
Next | Last |