[Koha] SQL Report Help

[Sharon Jackson]

Hi,

I'm trying to run a report that gives me a list of the most popular DVDs for
the current month.  When I run the report, I get a list of DVDs that all
have an issue count of one,(which I know is not the case). And when I look
at the checkout history for DVDs that I know are popular -  some don't
appear on the list at all, and all have an issue count much higher than one
for that time period.
Any ideas/help would be much appreciated

SELECT biblio.title,biblio.author,COUNT(*) AS issuecount FROM
issues,biblio,items WHERE items.biblionumber = biblio.biblionumber AND
issues.itemnumber= items.itemnumber AND issues.issuedate > '2010-02-28' AND
items.itype='DVD' GROUP BY biblio.biblionumber ORDER BY issuecount DESC
LIMIT 20

thanks
Sharon


--
Sharon Jackson
Librarian RLIANZA
Albany Senior High School
P O Box 300-380
Albany 0752
Phone.  (09)451 9065
Fax.  (09)451 9209
Mobile 021 020 60451
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100329/12477447/attachment.htm