select * from institution where ip1=34&netmask1 and ip2=227&netmask2 and ip3=112&netmask3 and ip4=145&netmask4 and datefrom<='2016' and dateto>='2016' and journal='sem'