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