| Lines 918-924
          sub GetPreviousSerialid {
      
      
        Link Here | 
        
          | 918 |                         FROM     serial | 918 |                         FROM     serial | 
        
          | 919 |                         WHERE    subscriptionid = ? | 919 |                         WHERE    subscriptionid = ? | 
        
          | 920 |                         AND      status = 2 | 920 |                         AND      status = 2 | 
          
            
              | 921 |                         ORDER BY serialid DESC LIMIT $nth,1  | 921 |                         ORDER BY serialid DESC LIMIT $nth,1 | 
        
          | 922 |                 "; | 922 |                 "; | 
        
          | 923 |     my $sth = $dbh->prepare($strsth); | 923 |     my $sth = $dbh->prepare($strsth); | 
        
          | 924 |     $sth->execute($subscriptionid); | 924 |     $sth->execute($subscriptionid); | 
  
    | Lines 1498-1504
          $subscriptionid = &NewSubscription($auser,branchcode,$aqbooksellerid,$cost,$aqbu
      
      
        Link Here | 
        
          | 1498 |     $lastvalue1,$innerloop1,$lastvalue2,$innerloop2,$lastvalue3,$innerloop3, | 1498 |     $lastvalue1,$innerloop1,$lastvalue2,$innerloop2,$lastvalue3,$innerloop3, | 
        
          | 1499 |     $status, $notes, $letter, $firstacquidate, $irregularity, $numberpattern, | 1499 |     $status, $notes, $letter, $firstacquidate, $irregularity, $numberpattern, | 
        
          | 1500 |     $locale, $callnumber, $manualhistory, $internalnotes, $serialsadditems, | 1500 |     $locale, $callnumber, $manualhistory, $internalnotes, $serialsadditems, | 
          
            
              | 1501 |     $staffdisplaycount, $opacdisplaycount, $graceperiod, $location, $enddate,  | 1501 |     $staffdisplaycount, $opacdisplaycount, $graceperiod, $location, $enddate, | 
        
          | 1502 |     $skip_serialseq, $itemtype, $previousitemtype); | 1502 |     $skip_serialseq, $itemtype, $previousitemtype); | 
        
          | 1503 |  | 1503 |  | 
        
          | 1504 | Create a new subscription with value given on input args. | 1504 | Create a new subscription with value given on input args. |