my %oi_by_id = map { $_->id => $_ } @$orderitems;
my $query = sprintf <<'', join ', ', ("?")x@all_doi_ids;
SELECT DISTINCT doi.id, closed FROM delivery_orders
my %oi_by_id = map { $_->id => $_ } @$orderitems;
my $query = sprintf <<'', join ', ', ("?")x@all_doi_ids;
SELECT DISTINCT doi.id, closed FROM delivery_orders