my @nodes = $self->fetch(
        select    => [
            $nodes->id,
            $nodes->path,
            coalesce(
                $nodest->nav,
                $nodest->title,
                $nodes->nav,
                $nodes->title)->as('nav'),
        ],
        from      => [$nodes,$nodes2],
        left_join => $nodest,
        on        => ($nodest->transof == $nodes->id) &
                     ($nodest->lang == $self->lang),
        where     => $nodes2->lft->between($nodes->lft, $nodes->rht) &
                     ($nodes2->id == $id),
        order_by  => $nodes->lft,
    );