select * from institution where ip1=100&netmask1 and ip2=26&netmask2 and ip3=35&netmask3 and ip4=111&netmask4 and datefrom<='2006' and dateto>='2006' and journal='sem'