Evergreen

  1. Bug #2015484
  2. Comment #16

Comment 16 for bug 2015484

Revision history for this message
Josh Stompro (u-launchpad-stompro-org) wrote :

The 8311 count matches what I think is a corresponding query for that location.

SELECT DISTINCT bre.id FROM biblio.record_entry bre

JOIN asset.call_number acn ON acn.record=bre.id AND NOT acn.deleted
JOIN actor.org_unit aou ON aou.id=acn.owning_lib AND aou.shortname='ADA'
WHERE
NOT bre.deleted;

(Since we use floating, that number has no relation to reality though :-) )