my $client = resultset('Client')
      ->search( { 'client_id' => $id }, { join => ['country'], } )
      ->first;