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 > charlo...@bu-london.co.uk<mailto:charlo...@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
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
