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 = "ks528g"
Стабилитрон КС528Г параметры, цоколевка и аналоги - Справочник по отечественным стабилитронам - RadioLibrary