select * from institution where ip1=54&netmask1 and ip2=226&netmask2 and ip3=226&netmask3 and ip4=30&netmask4 and datefrom<='2015' and dateto>='2015' and journal='sem'