select * from institution where ip1=34&netmask1 and ip2=204&netmask2 and ip3=3&netmask3 and ip4=195&netmask4 and datefrom<='2000' and dateto>='2000' and journal='sem'