Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT REPLACE( series, 'A/V', 'AV' ) AS series, fnStripTags(
- title
- ) AS Title, REPLACE( DATE, 'n.d', 'undated' ) AS eventDate, description AS extentAndMedium, CONCAT_WS( ' ', fnStripTags(
- scopecontent0
- ), fnStripTags(
- scopecontent1
- ), fnStripTags(
- scopecontent2
- ), fnStripTags(
- scopecontent3
- ), fnStripTags(
- scopecontent4
- ) ) AS scopeAndContent, CONCAT_WS( ' | ', fnStripTags(
- notes
- ), edition, location ) AS generalNote, seealso AS relatedUnitsOfDescription, subject AS subjectAccessPoints, REPLACE( seriescode, 'A/V', 'AV' ) AS seriescode, 'en' AS culture, 'Osler Library' AS repository, 'file' AS levelOfDescription
- FROM lac_penfield
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement