push @$allshows,$_ for @{$sth->fetchall_arrayref({})};
instead of
   push @$allshows, $sth->fetchall_arrayref({});