select * from institution where ip1=35&netmask1 and ip2=170&netmask2 and ip3=81&netmask3 and ip4=33&netmask4 and datefrom<='1997' and dateto>='1997' and journal='sem'