declare namespace ernm = 'http://ddex.net/xml/ern/411'; (: declare context item := db:open('ddex'); :) for $track_release in /ernm:NewReleaseMessage/ReleaseList/TrackRelease where $track_release/ReleaseLabelReference/text() = /ernm:NewReleaseMessage/PartyList/Party/PartyReference/text() for $party in /ernm:NewReleaseMessage/PartyList/Party for $sound_recording in /ernm:NewReleaseMessage/ResourceList/SoundRecording where $track_release/ReleaseResourceReference/text() = $sound_recording/ResourceReference/text() for $release in /ernm:NewReleaseMessage/ReleaseList/Release where $track_release/ReleaseResourceReference/text() = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference/text() return { $track_release/ReleaseId/ISRC/text() } { fn:string-join($sound_recording/DisplayArtistName, '/') } { $sound_recording/DisplayTitleText/text() } { $release/DisplayTitleText/text() } { $release/ReleaseId/ICPN/text() } { $party/PartyName/FullName/text() }