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