example1.pl

my @cart_items = $self->table->find(
                                      where=>[ $self->_c->session_condition ],
                                      with => [
                                                                                              
                                                {
                                                  name => 'Catalog.Image',
                                                  columns => [ 'url']
                                                },
                                                {
                                                  name => 'Catalog',
                                                  columns => [ 'name', 'url_uniq']
                                                }, 
                                                {
                                                  name => 'Catalog.Parent',
                                                  columns => ['url_uniq']
                                                },
                                               
                                              ],
                                      columns => [qw/unit price quantity summa catalog_id/],
                                      rows_as_hashes => 1
  );