From 0ec9cd1fbe94567e50180b8f85c9cab33a3eaf3c Mon Sep 17 00:00:00 2001 From: Nahuel ANGELINETTI Date: Thu, 2 Jul 2009 12:30:05 +0200 Subject: [PATCH] [followup](bug #3080) refix the sql request This fix the sql request that have some problems of synthax and a table repeated in "FROM". Signed-off-by: Henri-Damien LAURENT --- acqui/spent.pl | 7 ++----- 1 file changed, 2 insertions(+), 5 deletions(-) diff --git a/acqui/spent.pl b/acqui/spent.pl index c9c13ea3a6..b62f16d985 100755 --- a/acqui/spent.pl +++ b/acqui/spent.pl @@ -40,11 +40,8 @@ my $query = inner join aqorderbreakdown on aqorderbreakdown.ordernumber = aqorders.ordernumber inner join aqbasket on aqbasket.basketno = aqorders.basketno left join items on items.biblionumber=aqorders.biblionumber - where bookfundid=? and - aqorders.ordernumber=aqorderbreakdown.ordernumber and - aqorders.basketno=aqbasket.basketno - and ( - (datereceived >= ? and datereceived < ?)) + where bookfundid=? + and (datereceived >= ? and datereceived < ?) and (datecancellationprinted is NULL or datecancellationprinted='0000-00-00') -- 2.39.5