declare namespace ernm = 'http://ddex.net/xml/ern/411';
(: declare context item := db:open('ddex'); :)

for $track_release in /ernm:NewReleaseMessage/ReleaseList/TrackRelease[
  ReleaseLabelReference/text() =
  /ernm:NewReleaseMessage/PartyList/Party/PartyReference
]
for $sound_recording in /ernm:NewReleaseMessage/ResourceList/SoundRecording[
  ResourceReference/text() =
  $track_release/ReleaseResourceReference
]
for $release in /ernm:NewReleaseMessage/ReleaseList/Release[
  ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference/text() = $track_release/ReleaseResourceReference
]
  
for $party in /ernm:NewReleaseMessage/PartyList/Party
return <identity>
  <isrc>{ $track_release/ReleaseId/ISRC/text() }</isrc>
  <artist>{ fn:string-join($sound_recording/DisplayArtistName, '/') }</artist>
  <title>{ $sound_recording/DisplayTitleText/text() }</title>
  <album>{ $release/DisplayTitleText/text() }</album>
  <icpn>{ $release/ReleaseId/ICPN/text() }</icpn>
  <sublabel>{ $party/PartyName/FullName/text() }</sublabel>
</identity>