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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
