Novelist On the Shelf Extract

SELECT DISTINCT ON ("isbn", "itemid")
evergreen.isbn13(mrfr.value) AS "isbn",
acp.barcode AS "itemid",
btrim(regexp_replace(acn.label, E'\\s+',' ','g')) AS "bibrecordcallno",
acn.record AS "bibrecordid", rmsr.title AS "title"
FROM metabib.real_full_rec mrfr
JOIN asset.opac_visible_copies aovc ON mrfr.record = aovc.record
JOIN asset.copy acp ON acp.id = aovc.copy_id
JOIN asset.call_number acn ON acn.id = acp.call_number
JOIN reporter.materialized_simple_record rmsr ON rmsr.id = acn.record
WHERE mrfr.tag = '020'
AND mrfr.subfield IN ('a','z')
AND evergreen.isbn13(mrfr.value) IS NOT NULL