X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fevergreen_staged_report.xml;h=866a09c5e80836e5dfc646d6133f8cad2191a5cb;hp=47b2423547d4cf092b32093d1ecb76688f8e8880;hb=60e088b624dcf37cb71119b31a66b61d17e36efb;hpb=ea3559a4f7ac5fefcc0e64b1e610b26004d75d9f diff --git a/mig-xml/evergreen_staged_report.xml b/mig-xml/evergreen_staged_report.xml index 47b2423..866a09c 100644 --- a/mig-xml/evergreen_staged_report.xml +++ b/mig-xml/evergreen_staged_report.xml @@ -646,7 +646,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibs 1 Count - SELECT COUNT(eg) FROM bib_id_map + SELECT COUNT(id) FROM biblio_record_entry @@ -655,7 +655,7 @@ id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3 bibs 0 Count - SELECT COUNT(eg) FROM bib_id_map where eg::INTEGER NOT IN (SELECT DISTINCT record FROM asset_call_number) + SELECT COUNT(id) FROM biblio_record_entry where id NOT IN (SELECT DISTINCT record FROM asset_call_number)