select * from institution where ip1=216&netmask1 and ip2=73&netmask2 and ip3=216&netmask3 and ip4=181&netmask4 and datefrom<='er10' and dateto>='er10' and journal='sem'