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