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 <[email protected]> To: Lenora Oftedahl <[email protected]> Cc: koha-user <[email protected]> Sent: Monday, April 9, 2012 4:46 PM Subject: Re: [Koha] Ghost records On 10 April 2012 09:42, Lenora Oftedahl <[email protected]> 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 [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
