3 SELECT evergreen.upgrade_deps_block_check('1060', :eg_version);
5 DROP VIEW IF EXISTS extend_reporter.copy_count_per_org;
8 CREATE OR REPLACE VIEW extend_reporter.copy_count_per_org AS
9 SELECT acn.record AS bibid,
12 max(ac.edit_date) AS last_edit_time,
13 min(ac.deleted::integer) AS has_only_deleted_copies,
16 WHEN ac.deleted THEN ac.id
18 END) AS deleted_count,
21 WHEN NOT ac.deleted THEN ac.id
23 END) AS visible_count,
24 count(*) AS total_count
25 FROM asset.call_number acn,
27 WHERE ac.call_number = acn.id
28 GROUP BY acn.record, acn.owning_lib, ac.circ_lib;