@@ -, +, @@ wizard --- reports/serials_stats.pl | 1 + 1 file changed, 1 insertion(+) --- a/reports/serials_stats.pl +++ a/reports/serials_stats.pl @@ -135,6 +135,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, aqbooksellers.name ORDER BY aqbooksellers.name ASC "); $sth->execute(); --