[% FOREACH row = query.execute() %]
 if(exists $hash{[% row.ITEMS %]}{ [% row.TYPE %] }){
    $hash{ [% row.ITEMS %]}{[% row.TYPE %]}++;
  }
  else{
    $hash{ [% row.ITEMS %]}{[% row.TYPE %]} = 1;
[% END %]