dump vr formats

SELECT
    bre.id,
    bre.create_date,
    array_agg(DISTINCT SUBSTRING(mrfr007.value FROM '^v...(.)') ORDER BY SUBSTRING(mrfr007.value FROM '^v...(.)')) AS distinct_vr_formats,
    COUNT(DISTINCT mrfr007.id) AS total_vr_format_count
FROM metabib.real_full_rec mrfr007
JOIN biblio.record_entry bre ON mrfr007.record = bre.id
WHERE mrfr007.tag = '007' AND NOT bre.deleted AND mrfr007.value LIKE 'v____%'
AND substring(mrfr007.value FROM '^v...(.)') NOT IN ('|',' ','-')
GROUP BY 1,2
HAVING array_agg(distinct substring(mrfr007.value FROM '^v...(.)') ORDER BY substring(mrfr007.value FROM '^v...(.)')) NOT IN ('{s}','{v}','{s,v}','{b}')
ORDER BY 3, 2 DESC