<query>SELECT COUNT(ac.id), acl.name, aou.name, ac.x_migrate::TEXT FROM asset_copy_legacy ac JOIN asset.copy_location acl ON acl.id = ac.location JOIN actor.org_unit aou ON aou.id = ac.circ_lib GROUP BY 2, 3, 4 ORDER BY 2, 3, 4</query>
</report>
+ <report>
+ <name>asset_cops_w_loc_one</name>
+ <report_title>Copies with a Location of Stacks</report_title>
+ <tag>assets</tag>
+ <iteration>0</iteration>
+ <heading>Barcode</heading>
+ <query>SELECT barcode FROM asset_copy_legacy WHERE location = 1 AND x_migrate</query>
+ </report>
+
<!-- report>
<name>asset_barcode_lengths</name>
<report_title>Barcode Lengths by Library</report_title>