View | Details | Raw Unified | Return to bug 6893
Collapse All | Expand All

(-)a/C4/Suggestions.pm (-2 / +1 lines)
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
- 

Return to bug 6893