select * from institution where ip1=44&netmask1 and ip2=222&netmask2 and ip3=225&netmask3 and ip4=12&netmask4 and datefrom<='1994' and dateto>='1994' and journal='sem'