| Lines 224-230
          my $strsth =
      
      
        Link Here | 
        
          | 224 |     $sqldatewhere | 224 |     $sqldatewhere | 
        
          | 225 |     AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber) | 225 |     AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber) | 
        
          | 226 |     AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL) | 226 |     AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL) | 
          
            
              | 227 |     AND items.itemnumber NOT IN (select itemnumber FROM reserves where found IS NOT NULL) | 227 |     AND items.itemnumber NOT IN (SELECT itemnumber FROM reserves WHERE found IS NOT NULL AND itemnumber IS NOT NULL) | 
        
          | 228 |     AND issues.itemnumber IS NULL | 228 |     AND issues.itemnumber IS NULL | 
        
          | 229 |     AND reserves.priority <> 0  | 229 |     AND reserves.priority <> 0  | 
        
          | 230 |     AND reserves.suspend = 0 | 230 |     AND reserves.suspend = 0 | 
  
    | Lines 233-239
          my $strsth =
      
      
        Link Here | 
        
          | 233 |     "; | 233 |     "; | 
        
          | 234 |     # GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when  | 234 |     # GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when  | 
        
          | 235 |     #    multiple patrons have a hold on an item | 235 |     #    multiple patrons have a hold on an item | 
          
            
              | 236 |  | 236 | #FIXME "found IS NOT NULL AND itemnumber IS NOT NULL" is just a workaround: see BZ 25726 | 
        
          | 237 |  | 237 |  | 
        
          | 238 | if (C4::Context->preference('IndependentBranches')){ | 238 | if (C4::Context->preference('IndependentBranches')){ | 
        
          | 239 |     $strsth .= " AND items.holdingbranch=? "; | 239 |     $strsth .= " AND items.holdingbranch=? "; | 
            
              | 240 | -  |  |  |