Hi, please keep in mind that newer versions of Koha don't store the item information (952) in the marcxml any longer - so none of the records would have a 952. In order to find out which records have no items, you'd have to check for missing biblionumbers in the items table.
Hope this helps, Katrin Am 22.05.2015 um 04:58 schrieb Steven Nickerson: > Hi Lisa, > I hope this is what you were looking for.....the SQL below will list > biblionumber and ISBN for all biblioitems without 'tag="952"' in the marcxml > field: > > select biblionumber from biblioitems where marcxml NOT LIKE '%tag="952"%'; > > Hope this helps! > Steve > > -----Original Message----- > From: Peel Lisa [mailto:lisa.p...@ritz.edu] > Sent: Thursday, May 21, 2015 3:20 AM > To: koha@lists.katipo.co.nz > Subject: [Koha] Report on MARC tags > > Hello > > I am hoping someone can help me with a little bit of SQL. > > I need to export my whole catalogue but I have now realised that the 'simple > framework' some staff have been using to create bib items did not include > the 952 tag so this information is missing from those MARC records. > > So I now need to locate all bib items which do not have a 952 tag (I am > assuming I will need to manually edit the marc records to include the 952 > information even if I update the 'simple framework?) - if anyone would be > kind enough to provide the correct SQL for this report I would be extremely > grateful:-) > > Regards > > Lisa > > ________________________________ > > > Mrs Lisa Peel, Head of Learning Resources Services, SEG SEG, Swiss Education > Group Avenue des Alpes 27bis > CH-1820 Montreux, Switzerland > > Tel: +41 (0)79 228 0151 > Email: lp...@swisseducation.com<mailto:aas...@swisseducation.com> > Web: www.swisseducation.com<http://www.swisseducation.com/> > > [Facebook]<http://facebook.swisseducation.com/> [Twitter] > <http://twitter.swisseducation.com/> [Youtube] > <http://youtube.swisseducation.com/> [Google+] > <http://plus.swisseducation.com/> > > [http://www.swisseducation.com/email-signatures/image?co=SEG&id=1]<http://ww > w.swisseducation.com/email-signatures/link?co=SEG&id=1> > [http://www.swisseducation.com/email-signatures/image?co=SEG&id=2]<http://ww > w.swisseducation.com/email-signatures/link?co=SEG&id=2> > ________________________________ > > > Confidentiality and Disclaimer: > > This message contains confidential information and is intended only for the > individual named. Email messages are provided for informational purposes, > therefore the sender does not accept liability for any errors or omissions > in the contents of this message. > > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha