select * from institution where ip1=34&netmask1 and ip2=228&netmask2 and ip3=168&netmask3 and ip4=200&netmask4 and datefrom<='2011' and dateto>='2011' and journal='sem'