http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8127 Priority: P5 - low Change sponsored?: --- Bug ID: 8127 Assignee: gmcharlt@gmail.com Summary: Most Circulated Items not working right Severity: normal Classification: Unclassified OS: All Reporter: nengard@gmail.com Hardware: All Status: NEW Version: master Component: Reports Product: Koha I got this from a library: I'm trying to get the "Most Circulated Items" report to give me something and I am not having success. I chose a date range of 4 months, then I chose a library, then I chose a single item type (DVD1week) then I chose 20 for the limit, then I chose "library" for the "By" part of the limit and go an empty list. So I went back and changed "library" to "Itemtype." Now the system just hangs up spinning away without ever giving results. I wrote this to help for now - but the canned report should work: SELECT count(s.datetime) AS circs, b.title, b.author, i.ccode FROM statistics s JOIN items i USING (itemnumber) LEFT JOIN biblio b USING (biblionumber) WHERE DATE(s.datetime) > DATE_SUB(CURRENT_DATE(),INTERVAL 4 MONTH) AND DATE(s.datetime)<=CURRENT_DATE() AND s.itemnumber IS NOT NULL AND i.itype=<<Item type|itemtypes>> AND i.hombranch=<<Home branch|branches>> GROUP BY b.biblionumber ORDER BY circs DESC LIMIT 20 -- You are receiving this mail because: You are watching all bug changes.