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

[MASTeR Library]

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.