select * from institution where ip1=44&netmask1 and ip2=201&netmask2 and ip3=99&netmask3 and ip4=222&netmask4 and datefrom<='2017' and dateto>='2017' and journal='ose'