select * from institution where ip1=54&netmask1 and ip2=211&netmask2 and ip3=203&netmask3 and ip4=45&netmask4 and datefrom<='1999' and dateto>='1999' and journal='sem'