[Koha] Report help

[Charlotte Stock]

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!

List of titles with specific keyword
SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblionumber,'\">',biblionumber,'</a>')
AS bibnumber, lcsh
FROM
(SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="650"]/subfield[@code>="a"]')
AS lcsh FROM biblioitems)
AS subjects
WHERE lcsh
LIKE "%KEYWORD%"

Charlotte Stock
Librarian
charlotte at bu-london.co.uk<mailto:charlotte at 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 
---------------------------------------------------------------------------------------