@@ -, +, @@ LEFT JOIN items USING(itemnumber) LEFT JOIN biblio USING(biblionumber) LEFT JOIN biblioitems USING(biblionumber) LEFT JOIN borrowers USING(borrowernumber) WHERE 1 AND old_issues.issuedate > '2020-08-03' AND old_issues.issuedate < '2021-05-17' AND old_issues.returndate > '2020-08-27' AND old_issues.returndate < '2021-06-01' AND old_issues.branchcode like '403' AND items.itype like 'F' AND ccode like 'FIC' AND borrowers.categorycode like 'ST' group by biblio.biblionumber order by `RANK` DESC"] at /usr/local/koha_master/reports/cat_issues_top.pl line 67 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 --- reports/cat_issues_top.pl | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) --- a/reports/cat_issues_top.pl +++ a/reports/cat_issues_top.pl @@ -299,10 +299,10 @@ sub calculate { # Processing average loanperiods $strcalc .= "SELECT DISTINCT biblio.title, COUNT(biblio.biblionumber) AS `RANK`, biblio.biblionumber AS ID"; - $strcalc .= ", itemcallnumber as CALLNUM"; - $strcalc .= ", ccode as CCODE"; - $strcalc .= ", location as LOC"; - $strcalc .= " , $colfield " if ($colfield); + $strcalc .= ", GROUP_CONCAT(DISTINCT itemcallnumber) as CALLNUM"; + $strcalc .= ", GROUP_CONCAT(DISTINCT ccode) as CCODE"; + $strcalc .= ", GROUP_CONCAT(DISTINCT location) as LOC"; + $strcalc .= " , GROUP_CONCAT(DISTINCT $colfield) " if ($colfield); $strcalc .= " FROM `old_issues` LEFT JOIN items USING(itemnumber) LEFT JOIN biblio USING(biblionumber) --