Skip to content

Instantly share code, notes, and snippets.

@jamesvanmil

jamesvanmil/cdroms.sql

Created July 24, 2018 15:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jamesvanmil/6d2a182f00fd4505df8400c3377bf8ba to your computer and use it in GitHub Desktop.
Save jamesvanmil/6d2a182f00fd4505df8400c3377bf8ba to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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%'
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment