@@ -, +, @@ wizard --- reports/serials_stats.pl | 1 + 1 file changed, 1 insertion(+) --- a/reports/serials_stats.pl +++ a/reports/serials_stats.pl @@ -137,6 +137,7 @@ if($do_it){ my $sth = $dbh->prepare("SELECT aqbooksellerid, aqbooksellers.name FROM subscription LEFT JOIN aqbooksellers ON (subscription.aqbooksellerid=aqbooksellers.id ) + GROUP BY aqbooksellerid ORDER BY aqbooksellers.name ASC "); $sth->execute(); --