Try this --
SELECT count(s.datetime) AS circs, b.title, b.author, i.ccode
FROM statistics s
JOIN items i ON (i.itemnumber=s.itemnumber)
LEFT JOIN biblio b ON (b.biblionumber=i.biblionumber)
WHERE s.datetime BETWEEN <> AND <>
AND s.itemnumber IS NOT NULL AND s.type IN ('issue','renew') AND
i.ho
HI.
I got the SQL report below to generate the top 10 circulating books from
koha-community.
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.datetim
2 matches
Mail list logo
