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 '%12SA7%' AND yaxley.TubeList LIKE '%12SK7%' AND yaxley.TubeList LIKE '%12SQ7%' AND yaxley.TubeList LIKE '%50L6%' AND (companies.Company LIKE '%Em%' OR companies.tradename LIKE '%Em%') 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 '%12SA7%' AND combinedtable.TubeList LIKE '%12SK7%' AND combinedtable.TubeList LIKE '%12SQ7%' AND combinedtable.TubeList LIKE '%50L6%' AND (companies.Company LIKE '%Em%' OR companies.tradename LIKE '%Em%') 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 '%12SA7%' AND redbook.TubeList LIKE '%12SK7%' AND redbook.TubeList LIKE '%12SQ7%' AND redbook.TubeList LIKE '%50L6%' AND (companies.Company LIKE '%Em%' OR companies.tradename LIKE '%Em%') 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 | DR-343, 348, 349, 350, 352, DR1-343, 348, 350, 352 | DR & DR1 | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | R | |
| Emerson.Radio & Phono. Corporation | Emerson | DR343 (DR), DR1-143 (DR) | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y | ||
| Emerson.Radio & Phono. Corporation | Emerson | DR348 (DR), DRI348 (DRI), DR349 (DR) | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y | ||
| Emerson.Radio & Phono. Corporation | Emerson | DR350 (DR), DR1350 (DRI) | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y | ||
| Emerson.Radio & Phono. Corporation | Emerson | DR352 (DR), DRI352 (DRI) | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y | ||
| Emerson.Radio & Phono. Corporation | Emerson | DY-337, 349, 351, DYl-337, 349, 351 | 5 | 12SA7, 12SK7, 12SQ7, 35Z5, 50L6 | S | ||
| Emerson.Radio & Phono. Corporation | Emerson | DY337 (DY) DY1-349 (DY1) | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y | ||
| Emerson.Radio & Phono. Corporation | Emerson | DY337, 349, 351, DY1-337, 349, 351 | DY & DY1 | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | R | |
| Emerson.Radio & Phono. Corporation | Emerson | DY349 (DY) DY1-349 (DY1) | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y | ||
| Emerson.Radio & Phono. Corporation | Emerson | DY351 (DY) DY1-3519 (DY1) | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y | ||
| Emerson.Radio & Phono. Corporation | Emerson | EC-242, 296, 301, 314, 315, 323, 335, 336, 347, 353, 366, EC1- 242.296, 301, 314, 315, 323, 327, 335 | 5 | 12SA7, 12SK7, 12SQ7, 35Z5, 50L6 | S | ||
| Emerson.Radio & Phono. Corporation | Emerson | EC296 (EC), EC1-296 (EC1) | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y | ||
| Emerson.Radio & Phono. Corporation | Emerson | EC296, 301, 314, 315, 327, 336, 347, 353, 366, 376 | EC & EC2 | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | R | |
| Emerson.Radio & Phono. Corporation | Emerson | EC301 (EC), EC1-301 (EC1) | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y | ||
| Emerson.Radio & Phono. Corporation | Emerson | EC314 (EC), EC1-314 (EC1), EC315 (EC) | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y | ||
| Emerson.Radio & Phono. Corporation | Emerson | EC327 (EC), EC1-327 (EC1) | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y | ||
| Emerson.Radio & Phono. Corporation | Emerson | EC336 (EC), EC1-336 (ECI) | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y | ||
| Emerson.Radio & Phono. Corporation | Emerson | EC347 (EC), EC1-347 (ECU | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y | ||
| Emerson.Radio & Phono. Corporation | Emerson | EC353 (EC), EC1-353 (EC1) | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y | ||
| Emerson.Radio & Phono. Corporation | Emerson | EC366 (EC), EC1-366 (EC1) | 5 | 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 | Y |
| First | Previous | Next | Last |