Comment 2 for bug 1091885

Revision history for this message
Ben Shum (bshum) wrote :

Updating this bug with some slightly newer SQL for 2.6+ systems:

-- This tells you how many bibs are affected:
SELECT COUNT(*) FROM biblio.record_entry WHERE deleted = FALSE AND id NOT IN (SELECT source FROM metabib.record_attr_vector_list);

-- This tells you exactly which bibs are affected, by bib ID:
SELECT bre.id FROM biblio.record_entry bre LEFT JOIN metabib.record_attr_vector_list mravl ON mravl.source = bre.id WHERE bre.deleted = FALSE AND bre.active = TRUE AND mravl.vlist IS NULL;