my $allshows = $sth->fetchall_arrayref({}) };

print Dumper($allshows);

    $VAR1 = [{
            'title' => 'All Bets Are Off',
            'type' => '2',
            'number' => '215',
            'id' => '1'
            },
            {
            'title' => 'Who Is My Neighbor',
            'type' => '2',
            'number' => '217',
            'id' => '2'
            }];

##</code><code>##

push @$allshows, $sth->fetchall_arrayref({});
...
print Dumper(@$allshows);

    $VAR1 = [{
            'title' => 'All Bets Are Off',
            'type' => '2',
            'number' => '215',
            'id' => '1'
            }];
    $VAR2 = [{
            'title' => 'Who Is My Neighbor',
            'type' => '2',
            'number' => '217',
            'id' => '2'
            }];

##</code><code>##

...
push @$allshows, @{ $sth->fetchall_arrayref({}) };
...
print Dumper(@$allshows);

    $VAR1 = {
            'title' => 'All Bets Are Off',
            'type' => '2',
            'number' => '215',
            'id' => '1'
            };
    $VAR2 = {
            'title' => 'Who Is My Neighbor',
            'type' => '2',
            'number' => '217',
            'id' => '2'
            };

##</code><code>##

...
$allshows[0] .= $sth->fetchall_arrayref({});
...
print Dumper(\@allshows);

$VAR1 = [  'ARRAY(0x83db738)ARRAY(0x843ef94)'  ];