[Koha] In House Use

Ma. Victoria H. Silva-Manuel mavicsilva at gmail.com
Wed Mar 29 16:38:57 NZDT 2023


I am using the SQL report below to generate in house use:

> SELECT count(statistics.type), items.itemcallnumber
> 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 statistics.type='localuse' AND date(statistics.datetime) BETWEEN
> <<Date BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>   AND
> statistics.branch=<<Pick your branch|branches>> AND items.location =
> <<Location|loc>>
> GROUP BY items.itemcallnumber
> ORDER BY items.itemcallnumber asc


The original SQL only shows the count, I added the call number and filtered
it by library and location successfully but I cannot add the title. I am
always getting an error.
What should I do?
-- 
Ma. Victoria H. Silva-Manuel
Registered Librarian, 3892


More information about the Koha mailing list