Select Code to Download

package Schema::Document;
use base 'DBIx::Class::Core';
...
__PACKAGE__->set_primary_key('id');
__PACKAGE__->belongs_to('document' => 'Schema::Document_Author');
__PACKAGE__->belongs_to('author'   => 'Schema::Document_Author');

my $authorsInYear_RS = $schema->resultset('Author')->search({
    'document.document_id' => { 'IN'  =>  $doc_ids->as_query()  },
...
{
    prefetch => { document_authors => 'document' }
});