[Koha] Collection Code Totals

[Liz Rea]

Hi Kerrie,
Try adding on a GROUP BY ccode, as follows:

SELECT count(ccode), ccode AS collection FROM items WHERE homebranch =
'VIC' GROUP BY ccode;

Cheers,
Liz Rea
Catalyst IT Ltd.