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' )

Mallory-Yaxley Radio Encylopedia Database

Free radio look-up information

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.

Please select the database to search:
Records 1 to 20 of 111
Company Tradename Model Chassis # Tubes Tube List BallastDatabase
Emerson.Radio & Phono. Corporation Emerson 501, 502, 503, 504120000, 120029 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 R
Emerson.Radio & Phono. Corporation Emerson 501, 503, 504120000, 120029 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5
Emerson.Radio & Phono. Corporation Emerson 517120010 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 R
Emerson.Radio & Phono. Corporation Emerson 517 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5
Emerson.Radio & Phono. Corporation Emerson 519120030 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 R
Emerson.Radio & Phono. Corporation Emerson 519, 520120000, 120029 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5
Emerson.Radio & Phono. Corporation Emerson 525 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 R
Emerson.Radio & Phono. Corporation Emerson 525, 552120037 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5
Emerson.Radio & Phono. Corporation Emerson 539 5 12SA7/12BE6, 12SK7/12BA6, 12SQ7/12AT6, 50L6/50B5, 35Z5/35W4
Emerson.Radio & Phono. Corporation Emerson 539 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 R
Emerson.Radio & Phono. Corporation Emerson 541120005, 120010 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5
Emerson.Radio & Phono. Corporation Emerson 541120010 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 R
Emerson.Radio & Phono. Corporation Emerson 543, 544120052 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5
Emerson.Radio & Phono. Corporation Emerson Chassis FSFS 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 R
Emerson.Radio & Phono. Corporation Emerson DB-296, 301, 315, 327, DB1-301, DL-330, DL1-330, DW-330A, 330B, 358 5 12SA7, 12SK7, 12SQ7, 35Z5, 50L6 S
Emerson.Radio & Phono. Corporation Emerson DQ-333, 334, 343, 350, DQl-333, 334, DR-348, 352, DR1-343, 348, 352 5 12SA7, 12SK7, 12SQ7, 35Z5, 50L6 S
Emerson.Radio & Phono. Corporation Emerson DQ333, 334, 351, 398, DQ1-333, 334DQ & DQ1 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 R
Emerson.Radio & Phono. Corporation Emerson DQ333, DQ334, DQ1-333, DQ1-334 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 Y
Emerson.Radio & Phono. Corporation Emerson DQ351 (DQ) 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 Y
Emerson.Radio & Phono. Corporation Emerson DQ398 (DQ) 5 12SA7, 12SK7, 12SQ7, 50L6, 35Z5 Y

Next Last