Ah, I missed that. One way to handle it is to use the IN predicate of SQL instead of doing a loop:

"WHERE id IN (" . join ',',@ids . ")"

Another way would be to use the loop but instead of pushing the whole arrayref from the execute into your final array, you need to cycle through each arrayref and push that onto the final array:

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