[Koha-bugs] [Bug 10825] detail.tt displays duplicated enumchron values for serial items

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10825

--- Comment #17 from M. Tompsett <mtompset at hotmail.com> ---
In order to find one try select biblionumber,serialseq from serial and then use
one of those biblionumbers in the
http://STAFF/cgi-bin/koha/catalogue/detail.pl?biblionumber=### URL.

select serial.biblionumber as bibno,biblioitems.biblioitemnumber as
bibino,items.itemnumber as
itemno,items.dateaccessioned,items.enumchron,serialseq from
serial,biblioitems,items,serialitems where serial.serialid=serialitems.serialid
and serialitems.itemnumber=items.itemnumber and
serial.biblionumber=biblioitems.biblionumber and
biblioitems.biblioitemnumber=items.biblioitemnumber order by
biblioitems.biblionumber;

-- 
You are receiving this mail because:
You are watching all bug changes.