select ri.name as riname, r.name as rname from treferenceitem ri, treference r where r.reference="zenerdiod" and ri.reference = r.reference and nameitem = "ks417g"
Стабилитрон КС417Г параметры, цоколевка и аналоги - Справочник по отечественным стабилитронам - RadioLibrary