From d30aa81325b51ec41d98531f5d02ced2916fb6c3 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Fr=C3=A9d=C3=A9rick=20Capovilla?= Date: Tue, 10 Jan 2012 11:12:52 -0500 Subject: [PATCH] Corrects the SQL query used to fetch all baskets of a booksellers. Baskets containing only received items were made invisible with the old query. --- acqui/booksellers.pl | 1 - 1 files changed, 0 insertions(+), 1 deletions(-) diff --git a/acqui/booksellers.pl b/acqui/booksellers.pl index 2b16fe4..6fde06f 100755 --- a/acqui/booksellers.pl +++ b/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 -- 1.7.2.5