| Lines 299-308
          sub calculate {
      
      
        Link Here | 
        
          | 299 |      | 299 |      | 
        
          | 300 | # Processing average loanperiods | 300 | # Processing average loanperiods | 
        
          | 301 |     $strcalc .= "SELECT DISTINCT biblio.title, COUNT(biblio.biblionumber) AS `RANK`, biblio.biblionumber AS ID"; | 301 |     $strcalc .= "SELECT DISTINCT biblio.title, COUNT(biblio.biblionumber) AS `RANK`, biblio.biblionumber AS ID"; | 
          
            
              | 302 |     $strcalc .= ", itemcallnumber as CALLNUM"; | 302 |     $strcalc .= ", GROUP_CONCAT(DISTINCT itemcallnumber) as CALLNUM"; | 
            
              | 303 |     $strcalc .= ", ccode as CCODE"; | 303 |     $strcalc .= ", GROUP_CONCAT(DISTINCT ccode) as CCODE"; | 
            
              | 304 |     $strcalc .= ", location as LOC"; | 304 |     $strcalc .= ", GROUP_CONCAT(DISTINCT location) as LOC"; | 
            
              | 305 |     $strcalc .= " , $colfield " if ($colfield); | 305 |     $strcalc .= " , GROUP_CONCAT(DISTINCT $colfield) " if ($colfield); | 
        
          | 306 |     $strcalc .= " FROM `old_issues`  | 306 |     $strcalc .= " FROM `old_issues`  | 
        
          | 307 |                   LEFT JOIN items USING(itemnumber)  | 307 |                   LEFT JOIN items USING(itemnumber)  | 
        
          | 308 |                   LEFT JOIN biblio USING(biblionumber)  | 308 |                   LEFT JOIN biblio USING(biblionumber)  | 
            
              | 309 | -  |  |  |