gistfile1.txt

sub by_artist {
    my ($self, $artist) = @_;
    $self->search(
        { 'names.artist' => $artist->id },
        {
            join => [
                { artist => 'names' },
                'name'
            ],
            '+select' => [ 'name.name' ],
        }
    );
}