...
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'
            };