| 
      
            Lines 1076-1082
          sub GetAuthorisedValues {
      
      
        Link Here
      
     | 
  
        
          | 1076 | 
              if(@where_strings > 0) { | 
          1076 | 
              if(@where_strings > 0) { | 
        
        
          | 1077 | 
                  $query .= " WHERE " . join(" AND ", @where_strings); | 
          1077 | 
                  $query .= " WHERE " . join(" AND ", @where_strings); | 
        
        
          | 1078 | 
              }  | 
          1078 | 
              }  | 
        
          
            
              | 1079 | 
                  $query .= " GROUP BY lib ORDER BY category, " . ($opac ? "lib_opac, lib" : "lib, lib_opac");  | 
              1079 | 
                  $query .= " GROUP BY lib";  | 
            
            
               | 
               | 
              1080 | 
                  $query .= ' ORDER BY category, ' . (  | 
            
            
              | 1081 | 
                              $opac ? 'COALESCE(lib_opac, lib)'  | 
            
            
              | 1082 | 
                                    : 'lib, lib_opac'  | 
            
            
              | 1083 | 
                            );  | 
            
        
          | 1080 | 
           | 
          1084 | 
           | 
        
        
          | 1081 | 
              my $sth = $dbh->prepare($query);  | 
          1085 | 
              my $sth = $dbh->prepare($query);  | 
        
        
          | 1082 | 
           | 
          1086 | 
           | 
        
            
              | 1083 | 
              -   | 
               | 
               |