Hello all,
I need some report assistance. I want to add the summary (520a) to this report:
select count(statistics.datetime) as circs, CONCAT('<a
href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.title,'</a>')
AS Title, CONCAT('<a
href=\"http://mycatalogv/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'\">http://catalog.losgatosca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'</a>')
as URL, biblio.author, items.location from statistics join items on
(items.itemnumber=statistics.itemnumber) left join biblio on
(biblio.biblionumber=items.biblionumber) where
DATE(statistics.datetime) Between <<Date between (yyyy-mm-dd)>> and
<<and (yyyy-mm-dd)>> and statistics.itemnumber is not NULL and
location = <<Shelving Location Code>> group by biblio.biblionumber
order by circs DESC Limit 10
Can someone make some suggestions?
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
