Select Code to Download

  my $items = $self->db->resultset('Item')->search({},{
    '+select' => ...
...
    group_by => ...
    order_by => ...
  });

foreach my $value(@values) {
  my $results = $items->search({ 'joined_table.column' => $value });
...
  # Process and output results of this search
  ...
}

my $results_query = $items->search({ 'joined_table.column' => '?' });

...
  # Process and output results of this search
  ...
}