select * from institution where ip1=100&netmask1 and ip2=28&netmask2 and ip3=0&netmask3 and ip4=143&netmask4 and datefrom<='2010' and dateto>='2010' and journal='sem'