SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{be58cc801a16c743a3c5596db33bcb0b074c55189793c06c0edf68e03271a839}Haren{be58cc801a16c743a3c5596db33bcb0b074c55189793c06c0edf68e03271a839}' OR prCity = 'Haren' OR prZip = 'Haren' OR prStreet LIKE '{be58cc801a16c743a3c5596db33bcb0b074c55189793c06c0edf68e03271a839}Haren{be58cc801a16c743a3c5596db33bcb0b074c55189793c06c0edf68e03271a839}' OR prCountry = 'Haren') AND (prLocation LIKE '{be58cc801a16c743a3c5596db33bcb0b074c55189793c06c0edf68e03271a839}(Ems){be58cc801a16c743a3c5596db33bcb0b074c55189793c06c0edf68e03271a839}' OR prCity = '(Ems)' OR prZip = '(Ems)' OR prStreet LIKE '{be58cc801a16c743a3c5596db33bcb0b074c55189793c06c0edf68e03271a839}(Ems){be58cc801a16c743a3c5596db33bcb0b074c55189793c06c0edf68e03271a839}' OR prCountry = '(Ems)') AND (prLocation LIKE '{be58cc801a16c743a3c5596db33bcb0b074c55189793c06c0edf68e03271a839}Germany{be58cc801a16c743a3c5596db33bcb0b074c55189793c06c0edf68e03271a839}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{be58cc801a16c743a3c5596db33bcb0b074c55189793c06c0edf68e03271a839}Germany{be58cc801a16c743a3c5596db33bcb0b074c55189793c06c0edf68e03271a839}' OR prCountry = 'Germany')