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