SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{645d1e4503d184cdb9516cf31a0ae9b794ceee3a1b5bd2ef4c00b33071cdecb1}Haan{645d1e4503d184cdb9516cf31a0ae9b794ceee3a1b5bd2ef4c00b33071cdecb1}' OR prCity = 'Haan' OR prZip = 'Haan' OR prStreet LIKE '{645d1e4503d184cdb9516cf31a0ae9b794ceee3a1b5bd2ef4c00b33071cdecb1}Haan{645d1e4503d184cdb9516cf31a0ae9b794ceee3a1b5bd2ef4c00b33071cdecb1}' OR prCountry = 'Haan') AND (prLocation LIKE '{645d1e4503d184cdb9516cf31a0ae9b794ceee3a1b5bd2ef4c00b33071cdecb1}Germany{645d1e4503d184cdb9516cf31a0ae9b794ceee3a1b5bd2ef4c00b33071cdecb1}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{645d1e4503d184cdb9516cf31a0ae9b794ceee3a1b5bd2ef4c00b33071cdecb1}Germany{645d1e4503d184cdb9516cf31a0ae9b794ceee3a1b5bd2ef4c00b33071cdecb1}' OR prCountry = 'Germany')