select * from institution where ip1=18&netmask1 and ip2=117&netmask2 and ip3=196&netmask3 and ip4=217&netmask4 and datefrom<='2009' and dateto>='2009' and journal='sem'