for my $line (@data) {
    push @where, 'a.asset_id = ? and cc.serial_nr = ?';
    push @params, $line->{asset_id}, $line->{serial_nr};
}