projekt kivitendo

    # also search hits in makemodels, but only cache the results by id and merge later

    my $mm_query = qq|

      WHERE NOT parts.obsolete AND model ILIKE ? AND (make IS NULL OR make = ?);

    |;

    my $mm_results = selectall_hashref_query($::form, $dbh, $mm_query, '%' . $form->{"partnumber_$i"} . '%', $::form->{vendor_id});

           WHERE id = p.buchungsgruppen_id) = c1.id)

       LEFT JOIN chart c2 ON

         ((SELECT tc.income_accno_id

           WHERE tc.taxzone_id = '$taxzone_id' and tc.buchungsgruppen_id = p.buchungsgruppen_id) = c2.id)

       LEFT JOIN chart c3 ON

         ((SELECT tc.expense_accno_id