From e3c78da1eb60dd0e96fd35c72af8e30b44e12abc Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jean-Andr=C3=A9=20Santoni?= Date: Wed, 2 Dec 2009 17:23:55 +0100 Subject: [PATCH] [MT2435] Fixed the SQL syntax error in GetLateOrders --- C4/Acquisition.pm | 17 +++++++++-------- 1 file changed, 9 insertions(+), 8 deletions(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index 1f1132b9ca..a1238a4a8d 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -1493,15 +1493,16 @@ sub GetLateOrders { biblioitems.publicationyear, "; my $from = " - FROM ((( - (aqorders LEFT JOIN biblio ON biblio.biblionumber = aqorders.biblionumber) - LEFT JOIN biblioitems ON biblioitems.biblionumber = biblio.biblionumber) - LEFT JOIN aqbudgets ON aqorders.budget_id = aqbudgets.budget_id), - (aqbasket LEFT JOIN borrowers ON aqbasket.authorisedby = borrowers.borrowernumber) - LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id + FROM + aqorders LEFT JOIN biblio ON biblio.biblionumber = aqorders.biblionumber + LEFT JOIN biblioitems ON biblioitems.biblionumber = biblio.biblionumber + LEFT JOIN aqbudgets ON aqorders.budget_id = aqbudgets.budget_id, + aqbasket LEFT JOIN borrowers ON aqbasket.authorisedby = borrowers.borrowernumber + LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id WHERE aqorders.basketno = aqbasket.basketno - AND ( (datereceived = '' OR datereceived IS NULL) - OR (aqorders.quantityreceived < aqorders.quantity) + AND ( datereceived = '' + OR datereceived IS NULL + OR aqorders.quantityreceived < aqorders.quantity ) "; my $having = ""; -- 2.39.2