| Lines 113-119
          sub SearchSuggestion  {
      
      
        Link Here | 
        
          | 113 |     LEFT JOIN borrowers AS U2 ON managedby=U2.borrowernumber | 113 |     LEFT JOIN borrowers AS U2 ON managedby=U2.borrowernumber | 
        
          | 114 |     LEFT JOIN branches AS B2 ON B2.branchcode=U2.branchcode | 114 |     LEFT JOIN branches AS B2 ON B2.branchcode=U2.branchcode | 
        
          | 115 |     LEFT JOIN categories AS C2 ON C2.categorycode = U2.categorycode | 115 |     LEFT JOIN categories AS C2 ON C2.categorycode = U2.categorycode | 
          
            
              | 116 |     WHERE STATUS NOT IN ('ORDERED') | 116 |     WHERE 1=1 | 
        
          | 117 |     } , map { | 117 |     } , map { | 
        
          | 118 |         if ( my $s = $suggestion->{$_} ) { | 118 |         if ( my $s = $suggestion->{$_} ) { | 
        
          | 119 |         push @sql_params,'%'.$s.'%';  | 119 |         push @sql_params,'%'.$s.'%';  | 
            
              | 120 | -  |  |  |