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