http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5790 --- Comment #1 from Liz Rea <wizzyrea@gmail.com> 2011-02-22 15:43:26 UTC --- Here is a report that will show you bibs that have no items, but have orphan holds. To delete the holds (or notify patrons that the hold is being deleted due to no items in the collection), you will need to create a dummy item to see the holds. SELECT DISTINCT biblio.biblionumber, biblio.title FROM biblio LEFT JOIN items ON biblio.biblionumber = items.biblionumber LEFT JOIN reserves ON biblio.biblionumber = reserves.biblionumber WHERE items.itemnumber IS NULL and reserves.borrowernumber IS NOT NULL -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.