cdroms.sql

SELECT
  CONCAT('b', b.record_num, 'a'),
  s.marc_tag,
  s.content
FROM
  sierra_view.bib_view b
  JOIN sierra_view.subfield s ON b.id = s.record_id
WHERE
  s.marc_tag = '007'
  AND s.content LIKE '_o%'
;