fixed query to update host check