From f885665caeb46d4f4eae2e5b6d6eab71f9413cfb Mon Sep 17 00:00:00 2001 From: hdl Date: Mon, 21 Nov 2005 17:12:04 +0000 Subject: [PATCH] Bug Fix in issues_stats calculation --- reports/issues_stats.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/reports/issues_stats.pl b/reports/issues_stats.pl index 0788e75f0b..7ec65466be 100755 --- a/reports/issues_stats.pl +++ b/reports/issues_stats.pl @@ -455,7 +455,7 @@ sub calculate { my ($bookcount) = $rqbookcount->fetchrow; $strcalc .= "100*(COUNT(DISTINCT itemnumber))/ $bookcount " ; } - $strcalc .= "FROM statistics,borrowers where (statistics.borrowernumber=borrowers.borrowernumber) "; + $strcalc .= "FROM statistics,borrowers,issues where (statistics.borrowernumber=borrowers.borrowernumber) and issues.borrowernumber=borrowers.borrowernumber and issues.itemnumber=statistics.itemnumber "; @$filters[0]=~ s/\*/%/g if (@$filters[0]); $strcalc .= " AND statistics.datetime > '" . @$filters[0] ."'" if ( @$filters[0] ); -- 2.39.5