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 to "bi.isbn" but not working
SELECT count(s.datetime) AS circs, b.title, b.author,
i.ccode FROM statistics sJOIN items i ON
(i.itemnumber=s.itemnumber) LEFT JOIN biblio b ON
(b.biblionumber=i.biblionumber) WHERE DATE(s.datetime) >
DATE_SUB(CURRENT_DATE(),INTERVAL 6 MONTH)
AND DATE(s.datetime)<=CURRENT_DATE() AND
s.itemnumber IS NOT NULL AND s.type IN ('issue','renew')GROUP BY
b.biblionumber ORDER BY circs DESC LIMIT 10
--
Thanking you..
Librarian,
MAMCET <http://mamcet.com/>
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
