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