Hi, Try this: SELECT biblio.title, biblio.author, items.itemcallnumber, lcsh FROM (SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="650"]/subfield[@code>="a"]') AS lcsh FROM biblioitems) AS subjects JOIN biblio USING(biblionumber) JOIN items USING(biblionumber) WHERE lcsh LIKE "%KEYWORD%"; On 06/10/15 23:45, Charlotte Stock wrote:
This must be simple to fix but I'm not fluent enough in Koha-speak to crack the problem. Would anyone be able to help amend this SQL report, so that the results show the title, author and call number for each entry, instead of a hyperlinked biblionumber?
All suggestions gratefully received!
Charlotte Stock Librarian charlotte@bu-london.co.uk<mailto:charlotte@bu-london.co.uk>
Boston University Study Abroad London 43 Harrington Gardens London, SW7 4JU T 0207 244 6255 F 0207 373 9430 http://www.bu.edu/london/
Registered company in England no. FC020819 --------------------------------------------------------------------------------------- This email message has been delivered safely and archived online by Mimecast. For more information please visit http://www.mimecast.com ---------------------------------------------------------------------------------------
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- -- Liz Rea Catalyst.Net Limited Level 6, Catalyst House, 150 Willis Street, Wellington. P.O Box 11053, Manners Street, Wellington 6142 GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7