@@ -, +, @@ --- acqui/booksellers.pl | 1 - 1 files changed, 0 insertions(+), 1 deletions(-) --- a/acqui/booksellers.pl +++ a/acqui/booksellers.pl @@ -154,7 +154,6 @@ select aqbasket.*, count(*) as total, borrowers.firstname, borrowers.surname from aqbasket left join aqorders on aqorders.basketno = aqbasket.basketno left join borrowers on aqbasket.authorisedby = borrowers.borrowernumber where booksellerid = ? -AND ( aqorders.quantity > aqorders.quantityreceived OR quantityreceived IS NULL) AND datecancellationprinted IS NULL group by basketno ENDSQL --