[Koha] Circulation by Call Number

Ma. Victoria H. Silva-Manuel mavicsilva at gmail.com
Tue Sep 3 18:56:46 NZST 2019

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=borrowers.borrowernumber)
>   LEFT JOIN items ON (items.itemnumber = statistics.itemnumber)
>   LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber =
> items.biblioitemnumber)
> WHERE date(statistics.datetime) BETWEEN <<Date BETWEEN (yyyy-mm-dd)|date>>
> AND <<and (yyyy-mm-dd)|date>>
>                                AND statistics.branch = <<Branch|branches>>
>                                AND items.location = <<Location|loc>>
>                                AND statistics.itemtype = <<Item
> type|itemtypes>>
> GROUP BY items.itemcallnumber
> ORDER BY items.itemcallnumber ASC

I tried adding biblio.title in many places but it always ending up in error.
I'm not a programmer that is why I'm struggling with this.

Thank you.

Ma. Victoria H. Silva-Manuel
Registered Librarian, 3892

More information about the Koha mailing list