select * from institution where ip1=3&netmask1 and ip2=142&netmask2 and ip3=196&netmask3 and ip4=27&netmask4 and datefrom<='2007' and dateto>='2007' and journal='sem'