Lenora- I have seen something similar when the index is 'off'. Often a rebuild of the index clears this up. i.e. perl rebuild_zebra.pl -b -x -v -r -Joy Nelson Migration Specialist ByWater Solutions ________________________________ From: Chris Cormack <chris@bigballofwax.co.nz> To: Lenora Oftedahl <oftl@critfc.org> Cc: koha-user <koha@lists.katipo.co.nz> Sent: Monday, April 9, 2012 4:46 PM Subject: Re: [Koha] Ghost records On 10 April 2012 09:42, Lenora Oftedahl <oftl@critfc.org> wrote:
As far as I can tell, they aren't even biblios anymore. Is there some way to find items that are not attached to biblios?
Yup Try this SELECT itemnumber,barcode FROM items WHERE items.biblionumber NOT IN (SELECT biblionumber FROM biblio) Chris _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha