jberkus

SELECT
          h2.name                                                 AS "objectcsid",
          cc.objectnumber,
          h1.name                                                 AS "mediacsid",
          mc.description,
          bc.name,
          mc.creator                                                 creatorRefname,
          REGEXP_REPLACE(mc.creator, '^.*\)''(.*)''$', '\1')      AS "creator",
          mc.blobcsid,
          mc.copyrightstatement,