| 
      
            Lines 56-61
          SELECT
      
      
        Link Here
      
     | 
  
        
          | 56 | 
              quantity-quantityreceived AS tleft,  | 
          56 | 
              quantity-quantityreceived AS tleft,  | 
        
        
          | 57 | 
              ecost, budgetdate, entrydate,  | 
          57 | 
              ecost, budgetdate, entrydate,  | 
        
        
          | 58 | 
              aqbasket.booksellerid,  | 
          58 | 
              aqbasket.booksellerid,  | 
        
            
               | 
               | 
              59 | 
                  aqbooksellers.name as vendorname,  | 
            
        
          | 59 | 
              itype,  | 
          60 | 
              itype,  | 
        
        
          | 60 | 
              title  | 
          61 | 
              title  | 
        
        
          | 61 | 
          FROM (aqorders, aqbasket)  | 
          62 | 
          FROM (aqorders, aqbasket)  | 
        
  
    | 
      
            Lines 65-70
          LEFT JOIN aqorders_items ON
      
      
        Link Here
      
     | 
  
        
          | 65 | 
              aqorders.ordernumber=aqorders_items.ordernumber  | 
          66 | 
              aqorders.ordernumber=aqorders_items.ordernumber  | 
        
        
          | 66 | 
          LEFT JOIN items ON  | 
          67 | 
          LEFT JOIN items ON  | 
        
        
          | 67 | 
              items.itemnumber=aqorders_items.itemnumber  | 
          68 | 
              items.itemnumber=aqorders_items.itemnumber  | 
        
            
               | 
               | 
              69 | 
              LEFT JOIN aqbooksellers ON  | 
            
            
              | 70 | 
                  aqbasket.booksellerid = aqbooksellers.id  | 
            
        
          | 68 | 
          WHERE  | 
          71 | 
          WHERE  | 
        
        
          | 69 | 
              aqorders.basketno=aqbasket.basketno AND  | 
          72 | 
              aqorders.basketno=aqbasket.basketno AND  | 
        
        
          | 70 | 
              budget_id=? AND  | 
          73 | 
              budget_id=? AND  |