This report finds Authors not linked to authorities. But it only lists their names (some of them are quite prolific, and sometimes it's only one biblio that needs checking). How can I make the following give the biblio number as well as the name?
SELECT DISTINCT heading FROM ( SELECT ExtractValue(metadata, '//datafield[@tag="100"]/subfield[@code="a"]') AS heading FROM biblio_metadata WHERE length(ExtractValue(metadata, '//datafield[@tag="100"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(metadata, '//datafield[@tag="100"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(metadata, '//datafield[@tag="110"]/subfield[@code="a"]') AS heading FROM biblio_metadata WHERE length(ExtractValue(metadata, '//datafield[@tag="110"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(metadata, '//datafield[@tag="110"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(metadata, '//datafield[@tag="111"]/subfield[@code="a"]') AS heading FROM biblio_metadata WHERE length(ExtractValue(metadata, '//datafield[@tag="111"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(metadata, '//datafield[@tag="111"]/subfield[@code="9"]')) = 0 UNION SELECT ExtractValue(metadata, '//datafield[@tag="130"]/subfield[@code="a"]') AS heading FROM biblio_metadata WHERE length(ExtractValue(metadata, '//datafield[@tag="130"]/subfield[@code="a"]')) != 0 AND length(ExtractValue(metadata, '//datafield[@tag="130"]/subfield[@code="9"]')) = 0 ) AS heads ORDER BY heading Thanks in advance! Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha