SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{82170de19ff4e9671bd13c454224d0adfe16f4311c18fc50e26593d55d205aa1}Aurich{82170de19ff4e9671bd13c454224d0adfe16f4311c18fc50e26593d55d205aa1}' OR prCity = 'Aurich' OR prZip = 'Aurich' OR prStreet LIKE '{82170de19ff4e9671bd13c454224d0adfe16f4311c18fc50e26593d55d205aa1}Aurich{82170de19ff4e9671bd13c454224d0adfe16f4311c18fc50e26593d55d205aa1}' OR prCountry = 'Aurich') AND (prLocation LIKE '{82170de19ff4e9671bd13c454224d0adfe16f4311c18fc50e26593d55d205aa1}Ostfriesland{82170de19ff4e9671bd13c454224d0adfe16f4311c18fc50e26593d55d205aa1}' OR prCity = 'Ostfriesland' OR prZip = 'Ostfriesland' OR prStreet LIKE '{82170de19ff4e9671bd13c454224d0adfe16f4311c18fc50e26593d55d205aa1}Ostfriesland{82170de19ff4e9671bd13c454224d0adfe16f4311c18fc50e26593d55d205aa1}' OR prCountry = 'Ostfriesland') AND (prLocation LIKE '{82170de19ff4e9671bd13c454224d0adfe16f4311c18fc50e26593d55d205aa1}Germany{82170de19ff4e9671bd13c454224d0adfe16f4311c18fc50e26593d55d205aa1}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{82170de19ff4e9671bd13c454224d0adfe16f4311c18fc50e26593d55d205aa1}Germany{82170de19ff4e9671bd13c454224d0adfe16f4311c18fc50e26593d55d205aa1}' OR prCountry = 'Germany')