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