Annual Cleanup - Abandoned Records w/ Deleted Holdings

/* This is for deleting call number records and bib records where all their children (copies in the case of call numbers and
call numbers in the case of bibs) have been deleted.  This is a bit more complicated than cleaning up those who have never
had children.  Now, you may not need to do this.  If best cataloging practices are always followed you shouldn't have volumes or bibs floating out there after thier children are deleted but it can happen and here is how to clean it up. */

CREATE TABLE rogan.acn_delete AS
    SELECT id FROM asset.call_number WHERE deleted IS FALSE AND id NOT IN
    (SELECT DISTINCT(call_number) FROM asset.COPY WHERE deleted IS FALSE);

CREATE TABLE rogan.bib_delete AS
    SELECT id FROM biblio.record_entry WHERE deleted IS FALSE AND date(create_date) < '2010-10-01' AND id NOT IN (
    SELECT DISTINCT(record) FROM asset.call_number WHERE deleted IS FALSE);

update asset.call_number set deleted = TRUE where id in (select id from rogan.acn_delete);

update biblio.record_entry set deleted = true where id in (select id from rogan.bib_delete);

select count(id) from rogan.acn_delete;

select count(id) from rogan.bib_delete;