@@ -, +, @@ --- C4/Overdues.pm | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) --- a/C4/Overdues.pm +++ a/C4/Overdues.pm @@ -1237,10 +1237,10 @@ sub GetOverduesForBranch { my $i = 0; my $sth; if ($location) { - $sth = $dbh->prepare("$select AND items.location = ? ORDER BY borrowers.surname, borrowers.firstname"); + $sth = $dbh->prepare("$select AND items.location = ? GROUP BY borrowers.borrowernumber ORDER BY borrowers.surname, borrowers.firstname"); $sth->execute($branch, $location); } else { - $sth = $dbh->prepare("$select ORDER BY borrowers.surname, borrowers.firstname"); + $sth = $dbh->prepare("$select GROUP BY borrowers.borrowernumber ORDER BY borrowers.surname, borrowers.firstname"); $sth->execute($branch); } while ( my $data = $sth->fetchrow_hashref ) { --