Re: [Koha] Circulation by Call Number

Hi. Thank you for helping me out. I used the SQL you provided and edit a little bit because it shows error. Below is the final script that worked. SELECT count(statistics.type) AS 'Checkouts', (items.itemcallnumber) AS > 'Call Number', (items.barcode) AS 'Accession Number', biblio.title AS > 'Tit

Re: [Koha] Circulation by Call Number

Hello, Try this : SELECT biblio.title, count(statistics.type) AS 'Checkouts', (items.itemcallnumber) AS 'Call Number', (items.barcode) AS 'Accession Number' FROM borrowers LEFT JOIN statistics ON (statistics.borrowernumber=borrowers.borrowernumber) LEFT JOIN items ON (items.itemnumber = s

[Koha] Circulation by Call Number

How do I add title in the SQL report below to generate circulation statistics by call number? SELECT count(statistics.type) AS 'Checkouts', (items.itemcallnumber) AS > 'Call Number', (items.barcode) AS 'Accession Number' > FROM borrowers > LEFT JOIN statistics ON > (statistics.borrowernumber=bor