- (datecancellationprinted IS NULL OR
- datecancellationprinted='0000-00-00')
- GROUP BY aqorders.ordernumber
+ datecancellationprinted IS NULL AND
+ datereceived IS NOT NULL
+ GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber,
+ tleft,
+ budgetdate, entrydate,
+ aqbasket.booksellerid,
+ title,
+ aqorders.invoiceid,
+ aqinvoices.invoicenumber,
+ quantityreceived,
+ unitprice_tax_included,
+ datereceived,
+ aqbooksellers.name
+