Delete Copies Evergreen

magazine copies.sql

-- Magazines to delete
select acp.barcode, acp.create_date, aou.shortname

from asset.copy acp
join actor.org_unit aou on aou.id=acp.circ_lib
where acp.status=13
and acp.circ_modifier='Magazine'
and acp.deleted=false
order by acp.circ_lib
;