Re: [Koha] How to Create Top 10 Circulation book with ISBN report

Thanks a lot. On Tue, 26 Apr 2022, 9:09 pm Josh Barnes, wrote: > Hello! > > You're on the right track with adding the bi.isbn. The extra part you > missed is to tell your query which table the isbn is coming from. You can > do that by using another left join to add the biblioitems table. Try >

Re: [Koha] How to Create Top 10 Circulation book with ISBN report

Hello! You're on the right track with adding the bi.isbn. The extra part you missed is to tell your query which table the isbn is coming from. You can do that by using another left join to add the biblioitems table. Try something like this: SELECT count(s.datetime) AS circs, b.title, b.author,

[Koha] How to Create Top 10 Circulation book with ISBN report

Hi Is it possible to Create Top 10 Circulation book with ISBN number in SQL report, it is Available for Top Circulation book report: https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#Top_10_Circulating_Books , but ISBN number missing. How to Add the ISBN Number in the report. i try