Thank you for the suggestion Christian, and thank you for starting this project, which saves us from pains that we no doubt would have suffered were we to use Oracle XML DB!

I'll throw explicit text() steps in, and try to reduce the number of loops I'm doing. Conceptually there are really only two loops:

"for each document, iterate over each track, and pull out all of the other information referenced by that track"

Below is a single sample document. I wish I could make it smaller, but such is the problem I'm dealing with :)

<?xml version="1.0" encoding="UTF-8"?>
<ernm:NewReleaseMessage xmlns:ernm="http://ddex.net/xml/ern/411" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
LanguageAndScriptCode="en"
ReleaseProfileVersionId="Audio"
xsi:schemaLocation="http://ddex.net/xml/ern/411 http://ddex.net/xml/ern/411/release-notification.xsd">
<MessageHeader>
<MessageThreadId>xxx</MessageThreadId>
<MessageId>xxx</MessageId>
<MessageSender>
<PartyId>xxx</PartyId>
<PartyName>
<FullName>xxx</FullName>
</PartyName>
</MessageSender>
<MessageRecipient>
<PartyId>xxx</PartyId>
<PartyName>
<FullName>xxx</FullName>
</PartyName>
</MessageRecipient>
<MessageCreatedDateTime>xxx</MessageCreatedDateTime>
<MessageControlType>TestMessage</MessageControlType>
</MessageHeader>
<PartyList>
<Party>
<PartyReference>P1</PartyReference>
<PartyName>
<FullName>Sandy & Junior</FullName>
<KeyName>Sandy & Junior</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P2</PartyReference>
<PartyName>
<FullName>Moogie Canazio</FullName>
<NamesBeforeKeyName>Moogie</NamesBeforeKeyName>
<KeyName>Canazio</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P3</PartyReference>
<PartyName>
<FullName>Sandy</FullName>
<KeyName>Sandy</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P4</PartyReference>
<PartyName>
<FullName>Junior</FullName>
<KeyName>Junior</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P5</PartyReference>
<PartyName>
<FullName>Liah Soares</FullName>
<NamesBeforeKeyName>Liah</NamesBeforeKeyName>
<KeyName>Soares</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P6</PartyReference>
<PartyName>
<FullName>Márcio Cruz</FullName>
<NamesBeforeKeyName>Márcio</NamesBeforeKeyName>
<KeyName>Cruz</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P7</PartyReference>
<PartyName>
<FullName>Pedro Barezzi</FullName>
<NamesBeforeKeyName>Pedro</NamesBeforeKeyName>
<KeyName>Barezzi</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P8</PartyReference>
<PartyName>
<FullName>Danimar</FullName>
<KeyName>Danimar</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P9</PartyReference>
<PartyName>
<FullName>Junior</FullName>
<KeyName>Junior</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P10</PartyReference>
<PartyName>
<FullName>John Ondrasik</FullName>
<NamesBeforeKeyName>John</NamesBeforeKeyName>
<KeyName>Ondrasik</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P11</PartyReference>
<PartyName>
<FullName>Mauricio Gaetani</FullName>
<NamesBeforeKeyName>Mauricio</NamesBeforeKeyName>
<KeyName>Gaetani</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P12</PartyReference>
<PartyName>
<FullName>Otavio De Moraes</FullName>
<NamesBeforeKeyName>Otavio De</NamesBeforeKeyName>
<KeyName>Moraes</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P13</PartyReference>
<PartyName>
<FullName>Francesco Boccia</FullName>
<NamesBeforeKeyName>Francesco</NamesBeforeKeyName>
<KeyName>Boccia</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P14</PartyReference>
<PartyName>
<FullName>Gianfranco Calliendo</FullName>
<NamesBeforeKeyName>Gianfranco</NamesBeforeKeyName>
<KeyName>Calliendo</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P15</PartyReference>
<PartyName>
<FullName>Ciro Esposito</FullName>
<NamesBeforeKeyName>Ciro</NamesBeforeKeyName>
<KeyName>Esposito</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P16</PartyReference>
<PartyName>
<FullName>Ricardo Moreira</FullName>
<NamesBeforeKeyName>Ricardo</NamesBeforeKeyName>
<KeyName>Moreira</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P17</PartyReference>
<PartyName>
<FullName>Alanis Morissette</FullName>
<NamesBeforeKeyName>Alanis</NamesBeforeKeyName>
<KeyName>Morissette</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P18</PartyReference>
<PartyName>
<FullName>Roberto Carlos</FullName>
<NamesBeforeKeyName>Roberto</NamesBeforeKeyName>
<KeyName>Carlos</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P19</PartyReference>
<PartyName>
<FullName>Sandy</FullName>
<KeyName>Sandy</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P20</PartyReference>
<PartyName>
<FullName>Guilherme Lamounier</FullName>
<NamesBeforeKeyName>Guilherme</NamesBeforeKeyName>
<KeyName>Lamounier</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P21</PartyReference>
<PartyName>
<FullName>Nando</FullName>
<KeyName>Nando</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P22</PartyReference>
<PartyName>
<FullName>Kiko</FullName>
<KeyName>Kiko</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P23</PartyReference>
<PartyName>
<FullName>Ricardo Feghali</FullName>
<NamesBeforeKeyName>Ricardo</NamesBeforeKeyName>
<KeyName>Feghali</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P24</PartyReference>
<PartyName>
<FullName>Per Nylen</FullName>
<NamesBeforeKeyName>Per</NamesBeforeKeyName>
<KeyName>Nylen</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P25</PartyReference>
<PartyName>
<FullName>Andreas Carlsson</FullName>
<NamesBeforeKeyName>Andreas</NamesBeforeKeyName>
<KeyName>Carlsson</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P26</PartyReference>
<PartyName>
<FullName>Julie Morrison</FullName>
<NamesBeforeKeyName>Julie</NamesBeforeKeyName>
<KeyName>Morrison</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P27</PartyReference>
<PartyName>
<FullName>Jane Vaughn</FullName>
<KeyName>Jane Vaughn</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P28</PartyReference>
<PartyName>
<FullName>Karsten Dahlgaard</FullName>
<NamesBeforeKeyName>Karsten</NamesBeforeKeyName>
<KeyName>Dahlgaard</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P29</PartyReference>
<PartyName>
<FullName>Johnny Pedersen</FullName>
<NamesBeforeKeyName>Johnny</NamesBeforeKeyName>
<KeyName>Pedersen</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P30</PartyReference>
<PartyName>
<FullName>Milton Guedes</FullName>
<NamesBeforeKeyName>Milton</NamesBeforeKeyName>
<KeyName>Guedes</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P31</PartyReference>
<PartyName>
<FullName>Paulinho Galvão</FullName>
<NamesBeforeKeyName>Paulinho</NamesBeforeKeyName>
<KeyName>Galvão</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P32</PartyReference>
<PartyName>
<FullName>Lloyd "Gitsy" Oliver Willis</FullName>
<NamesBeforeKeyName>Lloyd "Gitsy" Oliver</NamesBeforeKeyName>
<KeyName>Willis</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P33</PartyReference>
<PartyName>
<FullName>Robbie Shakespeare</FullName>
<NamesBeforeKeyName>Robbie</NamesBeforeKeyName>
<KeyName>Shakespeare</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P34</PartyReference>
<PartyName>
<FullName>Everton Bonner</FullName>
<NamesBeforeKeyName>Everton</NamesBeforeKeyName>
<KeyName>Bonner</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P35</PartyReference>
<PartyName>
<FullName>Joseph Bonner</FullName>
<NamesBeforeKeyName>Joseph</NamesBeforeKeyName>
<KeyName>Bonner</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P36</PartyReference>
<PartyName>
<FullName>John Taylor</FullName>
<NamesBeforeKeyName>John</NamesBeforeKeyName>
<KeyName>Taylor</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P37</PartyReference>
<PartyName>
<FullName>Sly Dunbar</FullName>
<NamesBeforeKeyName>Sly</NamesBeforeKeyName>
<KeyName>Dunbar</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P38</PartyReference>
<PartyName>
<FullName>Pedro Abrunhosa</FullName>
<NamesBeforeKeyName>Pedro</NamesBeforeKeyName>
<KeyName>Abrunhosa</KeyName>
</PartyName>
</Party>
<Party>
<PartyReference>P39</PartyReference>
<PartyName>
<FullName>Universal Music International Ltda.</FullName>
</PartyName>
</Party>
</PartyList>
<ResourceList>
<SoundRecording>
<ResourceReference>A1</ResourceReference>
<Type>MusicalWorkSoundRecording</Type>
<ResourceId>
<ISRC>BRMCA0200733</ISRC>
</ResourceId>
<DisplayTitleText IsDefault="true">Não Dá Pra Não Pensar</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Não Dá Pra Não Pensar</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Não Dá Pra Não Pensar</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P2</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="2">
<ContributorPartyReference>P3</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="3">
<ContributorPartyReference>P4</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
<Role>ComposerLyricist</Role>
</Contributor>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music International</PLineCompany>
<PLineText>℗ 2002 Universal Music International</PLineText>
</PLine>
<Duration>PT4M50S</Duration>
<CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12
</CreationDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<LanguageOfPerformance>pt</LanguageOfPerformance>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T15</TechnicalResourceDetailsReference>
<AudioCodecType>FLAC</AudioCodecType>
<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<Duration>PT0H4M50.000S</Duration>
<IsPreview>false</IsPreview>
<File>
<URI>00044006704722_T15_audtrk.flac</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>D0DA7A0C4FBB86CFF71FE185E7D04EDB</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</SoundRecording>
<SoundRecording>
<ResourceReference>A2</ResourceReference>
<Type>MusicalWorkSoundRecording</Type>
<ResourceId>
<ISRC>BRMCA0200734</ISRC>
</ResourceId>
<DisplayTitleText IsDefault="true">Nada É Por Acaso</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Nada É Por Acaso</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Nada É Por Acaso</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P2</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="2">
<ContributorPartyReference>P3</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="3">
<ContributorPartyReference>P4</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="4">
<ContributorPartyReference>P5</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="5">
<ContributorPartyReference>P6</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="6">
<ContributorPartyReference>P7</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="7">
<ContributorPartyReference>P8</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music International</PLineCompany>
<PLineText>℗ 2002 Universal Music International</PLineText>
</PLine>
<Duration>PT4M21S</Duration>
<CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12
</CreationDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<LanguageOfPerformance>pt</LanguageOfPerformance>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T14</TechnicalResourceDetailsReference>
<AudioCodecType>FLAC</AudioCodecType>
<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<Duration>PT0H4M21.000S</Duration>
<IsPreview>false</IsPreview>
<File>
<URI>00044006704722_T14_audtrk.flac</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>0D7EE7708A5CE62C75CBB9B5754C1B4D</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</SoundRecording>
<SoundRecording>
<ResourceReference>A3</ResourceReference>
<Type>MusicalWorkSoundRecording</Type>
<ResourceId>
<ISRC>BRMCA0200724</ISRC>
</ResourceId>
<DisplayTitleText IsDefault="true">Super-Herói (Não É Fácil)</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Super-Herói (Não É Fácil)</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Super-Herói (Não É Fácil)</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P2</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="2">
<ContributorPartyReference>P3</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="3">
<ContributorPartyReference>P9</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="4">
<ContributorPartyReference>P10</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="5">
<ContributorPartyReference>P11</ContributorPartyReference>
<Role>Translator</Role>
</Contributor>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music International</PLineCompany>
<PLineText>℗ 2002 Universal Music International</PLineText>
</PLine>
<Duration>PT4M14S</Duration>
<CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12
</CreationDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<LanguageOfPerformance>pt</LanguageOfPerformance>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T13</TechnicalResourceDetailsReference>
<AudioCodecType>FLAC</AudioCodecType>
<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<Duration>PT0H4M13.000S</Duration>
<IsPreview>false</IsPreview>
<File>
<URI>00044006704722_T13_audtrk.flac</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>E3EAC70ED4B59307191AE87D80084548</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</SoundRecording>
<SoundRecording>
<ResourceReference>A4</ResourceReference>
<Type>MusicalWorkSoundRecording</Type>
<ResourceId>
<ISRC>BRMCA0200744</ISRC>
</ResourceId>
<DisplayTitleText IsDefault="true">Deixa Eu Tentar</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Deixa Eu Tentar</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Deixa Eu Tentar</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P2</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="2">
<ContributorPartyReference>P3</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="3">
<ContributorPartyReference>P4</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="4">
<ContributorPartyReference>P12</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music International</PLineCompany>
<PLineText>℗ 2002 Universal Music International</PLineText>
</PLine>
<Duration>PT4M53S</Duration>
<CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12
</CreationDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<LanguageOfPerformance>pt</LanguageOfPerformance>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T12</TechnicalResourceDetailsReference>
<AudioCodecType>FLAC</AudioCodecType>
<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<Duration>PT0H4M53.000S</Duration>
<IsPreview>false</IsPreview>
<File>
<URI>00044006704722_T12_audtrk.flac</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>764951DA059C70123A726D329FF5462A</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</SoundRecording>
<SoundRecording>
<ResourceReference>A5</ResourceReference>
<Type>MusicalWorkSoundRecording</Type>
<ResourceId>
<ISRC>BRMCA0200735</ISRC>
</ResourceId>
<DisplayTitleText IsDefault="true">Quando Você Passa (Turu Turu)</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Quando Você Passa (Turu Turu)</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Quando Você Passa (Turu Turu)</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P2</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="2">
<ContributorPartyReference>P3</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="3">
<ContributorPartyReference>P4</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="4">
<ContributorPartyReference>P13</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="5">
<ContributorPartyReference>P14</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="6">
<ContributorPartyReference>P15</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="7">
<ContributorPartyReference>P16</ContributorPartyReference>
<Role>Translator</Role>
</Contributor>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music International</PLineCompany>
<PLineText>℗ 2002 Universal Music International</PLineText>
</PLine>
<Duration>PT3M52S</Duration>
<CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12
</CreationDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<LanguageOfPerformance>pt</LanguageOfPerformance>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T11</TechnicalResourceDetailsReference>
<AudioCodecType>FLAC</AudioCodecType>
<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<Duration>PT0H3M51.000S</Duration>
<IsPreview>false</IsPreview>
<File>
<URI>00044006704722_T11_audtrk.flac</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>C037C6F6579786DA17817D2CA43975E5</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</SoundRecording>
<SoundRecording>
<ResourceReference>A6</ResourceReference>
<Type>MusicalWorkSoundRecording</Type>
<ResourceId>
<ISRC>BRMCA0200743</ISRC>
</ResourceId>
<DisplayTitleText IsDefault="true">Uninvited</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Uninvited</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Uninvited</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P2</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="2">
<ContributorPartyReference>P3</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="3">
<ContributorPartyReference>P4</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="4">
<ContributorPartyReference>P17</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music International</PLineCompany>
<PLineText>℗ 2002 Universal Music International</PLineText>
</PLine>
<Duration>PT4M47S</Duration>
<CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12
</CreationDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<LanguageOfPerformance>en</LanguageOfPerformance>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T10</TechnicalResourceDetailsReference>
<AudioCodecType>FLAC</AudioCodecType>
<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<Duration>PT0H4M46.000S</Duration>
<IsPreview>false</IsPreview>
<File>
<URI>00044006704722_T10_audtrk.flac</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>D6B0CC56A1FE3B1953C78786D933058B</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</SoundRecording>
<SoundRecording>
<ResourceReference>A7</ResourceReference>
<Type>MusicalWorkSoundRecording</Type>
<ResourceId>
<ISRC>BRMCA0200725</ISRC>
</ResourceId>
<DisplayTitleText IsDefault="true">Como É Grande O Meu Amor Por Você</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Como É Grande O Meu Amor Por Você</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Como É Grande O Meu Amor Por Você</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P2</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="2">
<ContributorPartyReference>P3</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="3">
<ContributorPartyReference>P4</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="4">
<ContributorPartyReference>P18</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music International</PLineCompany>
<PLineText>℗ 2002 Universal Music International</PLineText>
</PLine>
<Duration>PT2M50S</Duration>
<CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12
</CreationDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<LanguageOfPerformance>pt</LanguageOfPerformance>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T9</TechnicalResourceDetailsReference>
<AudioCodecType>FLAC</AudioCodecType>
<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<Duration>PT0H2M49.000S</Duration>
<IsPreview>false</IsPreview>
<File>
<URI>00044006704722_T9_audtrk.flac</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>7E752408F66B43CBE9EBA14B59A52BF8</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</SoundRecording>
<SoundRecording>
<ResourceReference>A8</ResourceReference>
<Type>MusicalWorkSoundRecording</Type>
<ResourceId>
<ISRC>BRMCA0200736</ISRC>
</ResourceId>
<DisplayTitleText IsDefault="true">Enrosca</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Enrosca</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Enrosca</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P2</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="2">
<ContributorPartyReference>P19</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="3">
<ContributorPartyReference>P4</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="4">
<ContributorPartyReference>P20</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music International</PLineCompany>
<PLineText>℗ 2002 Universal Music International</PLineText>
</PLine>
<Duration>PT3M32S</Duration>
<CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12
</CreationDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<LanguageOfPerformance>pt</LanguageOfPerformance>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T8</TechnicalResourceDetailsReference>
<AudioCodecType>FLAC</AudioCodecType>
<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<Duration>PT0H3M31.000S</Duration>
<IsPreview>false</IsPreview>
<File>
<URI>00044006704722_T8_audtrk.flac</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>C0657E94D28F126B6A8796425B2CFC5B</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</SoundRecording>
<SoundRecording>
<ResourceReference>A9</ResourceReference>
<Type>MusicalWorkSoundRecording</Type>
<ResourceId>
<ISRC>BRMCA0200737</ISRC>
</ResourceId>
<DisplayTitleText IsDefault="true">A Lenda</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>A Lenda</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>A Lenda</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P2</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="2">
<ContributorPartyReference>P3</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="3">
<ContributorPartyReference>P4</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="4">
<ContributorPartyReference>P21</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="5">
<ContributorPartyReference>P22</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="6">
<ContributorPartyReference>P23</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music International</PLineCompany>
<PLineText>℗ 2002 Universal Music International</PLineText>
</PLine>
<Duration>PT4M38S</Duration>
<CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12
</CreationDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<LanguageOfPerformance>pt</LanguageOfPerformance>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T7</TechnicalResourceDetailsReference>
<AudioCodecType>FLAC</AudioCodecType>
<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<Duration>PT0H4M37.000S</Duration>
<IsPreview>false</IsPreview>
<File>
<URI>00044006704722_T7_audtrk.flac</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>BE335EAE070F07470B785ABA05451BE6</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</SoundRecording>
<SoundRecording>
<ResourceReference>A10</ResourceReference>
<Type>MusicalWorkSoundRecording</Type>
<ResourceId>
<ISRC>BRMCA0200738</ISRC>
</ResourceId>
<DisplayTitleText IsDefault="true">Words Are Not Enough</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Words Are Not Enough</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Words Are Not Enough</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P2</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="2">
<ContributorPartyReference>P3</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="3">
<ContributorPartyReference>P4</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="4">
<ContributorPartyReference>P24</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="5">
<ContributorPartyReference>P25</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music International</PLineCompany>
<PLineText>℗ 2002 Universal Music International</PLineText>
</PLine>
<Duration>PT3M34S</Duration>
<CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12
</CreationDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<LanguageOfPerformance>en</LanguageOfPerformance>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T6</TechnicalResourceDetailsReference>
<AudioCodecType>FLAC</AudioCodecType>
<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<Duration>PT0H3M34.000S</Duration>
<IsPreview>false</IsPreview>
<File>
<URI>00044006704722_T6_audtrk.flac</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>4EDBF599C3C2876D83B0AF877AF7577D</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</SoundRecording>
<SoundRecording>
<ResourceReference>A11</ResourceReference>
<Type>MusicalWorkSoundRecording</Type>
<ResourceId>
<ISRC>BRMCA0200739</ISRC>
</ResourceId>
<DisplayTitleText IsDefault="true">Love Never Fails</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Love Never Fails</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Love Never Fails</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P2</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="2">
<ContributorPartyReference>P3</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="3">
<ContributorPartyReference>P4</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="4">
<ContributorPartyReference>P26</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="5">
<ContributorPartyReference>P27</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="6">
<ContributorPartyReference>P28</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="7">
<ContributorPartyReference>P29</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music International</PLineCompany>
<PLineText>℗ 2002 Universal Music International</PLineText>
</PLine>
<Duration>PT4M10S</Duration>
<CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12
</CreationDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<LanguageOfPerformance>en</LanguageOfPerformance>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T5</TechnicalResourceDetailsReference>
<AudioCodecType>FLAC</AudioCodecType>
<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<Duration>PT0H4M10.000S</Duration>
<IsPreview>false</IsPreview>
<File>
<URI>00044006704722_T5_audtrk.flac</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>23A44A17289D6CC6796998DE5081E465</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</SoundRecording>
<SoundRecording>
<ResourceReference>A12</ResourceReference>
<Type>MusicalWorkSoundRecording</Type>
<ResourceId>
<ISRC>BRMCA0200740</ISRC>
</ResourceId>
<DisplayTitleText IsDefault="true">O Amor Faz</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>O Amor Faz</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>O Amor Faz</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P2</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="2">
<ContributorPartyReference>P3</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="3">
<ContributorPartyReference>P4</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="4">
<ContributorPartyReference>P11</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music International</PLineCompany>
<PLineText>℗ 2002 Universal Music International</PLineText>
</PLine>
<Duration>PT4M36S</Duration>
<CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12
</CreationDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<LanguageOfPerformance>pt</LanguageOfPerformance>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T4</TechnicalResourceDetailsReference>
<AudioCodecType>FLAC</AudioCodecType>
<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<Duration>PT0H4M35.000S</Duration>
<IsPreview>false</IsPreview>
<File>
<URI>00044006704722_T4_audtrk.flac</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>DFF2D6AEC7D87F8D4D317B1372D4CC97</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</SoundRecording>
<SoundRecording>
<ResourceReference>A13</ResourceReference>
<Type>MusicalWorkSoundRecording</Type>
<ResourceId>
<ISRC>BRMCA0200741</ISRC>
</ResourceId>
<DisplayTitleText IsDefault="true">A Gente Dá Certo</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>A Gente Dá Certo</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>A Gente Dá Certo</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P2</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="2">
<ContributorPartyReference>P3</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="3">
<ContributorPartyReference>P4</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="4">
<ContributorPartyReference>P30</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music International</PLineCompany>
<PLineText>℗ 2002 Universal Music International</PLineText>
</PLine>
<Duration>PT4M17S</Duration>
<CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12
</CreationDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<LanguageOfPerformance>pt</LanguageOfPerformance>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T3</TechnicalResourceDetailsReference>
<AudioCodecType>FLAC</AudioCodecType>
<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<Duration>PT0H4M17.000S</Duration>
<IsPreview>false</IsPreview>
<File>
<URI>00044006704722_T3_audtrk.flac</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>C83A3CE4AAD1F3E4407E6CEA7C892B12</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</SoundRecording>
<SoundRecording>
<ResourceReference>A14</ResourceReference>
<Type>MusicalWorkSoundRecording</Type>
<ResourceId>
<ISRC>BRMCA0200742</ISRC>
</ResourceId>
<DisplayTitleText IsDefault="true">Cai A Chuva / Me Diz / Citação: Não Posso Mais</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Cai A Chuva / Me Diz / Citação: Não Posso Mais</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Cai A Chuva / Me Diz / Citação: Não Posso Mais</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P2</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="2">
<ContributorPartyReference>P3</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="3">
<ContributorPartyReference>P4</ContributorPartyReference>
<Role>AssociatedPerformer</Role>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role>
</Contributor>
<Contributor SequenceNumber="4">
<ContributorPartyReference>P30</ContributorPartyReference>
<Role>ComposerLyricist</Role>
<Role>Translator</Role>
</Contributor>
<Contributor SequenceNumber="5">
<ContributorPartyReference>P31</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="6">
<ContributorPartyReference>P32</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="7">
<ContributorPartyReference>P33</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="8">
<ContributorPartyReference>P34</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="9">
<ContributorPartyReference>P35</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="10">
<ContributorPartyReference>P36</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="11">
<ContributorPartyReference>P37</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<Contributor SequenceNumber="12">
<ContributorPartyReference>P38</ContributorPartyReference>
<Role>ComposerLyricist</Role>
</Contributor>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music International</PLineCompany>
<PLineText>℗ 2002 Universal Music International</PLineText>
</PLine>
<Duration>PT5M14S</Duration>
<CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12
</CreationDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<LanguageOfPerformance>pt</LanguageOfPerformance>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T2</TechnicalResourceDetailsReference>
<AudioCodecType>FLAC</AudioCodecType>
<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<Duration>PT0H5M13.000S</Duration>
<IsPreview>false</IsPreview>
<File>
<URI>00044006704722_T2_audtrk.flac</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>5DC6BD4B66CE9AC8376210A3D497605A</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</SoundRecording>
<Image>
<ResourceReference>A15</ResourceReference>
<Type>FrontCoverImage</Type>
<ResourceId>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">06UMGIM33173</ProprietaryId>
</ResourceId>
<DisplayTitleText IsDefault="true">Sandy & Júnior Ao Vivo No Maracanã</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Sandy & Júnior Ao Vivo No Maracanã</TitleText>
<SubTitle>Ao Vivo</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Sandy & Júnior Ao Vivo No Maracanã</TitleText>
<SubTitle>Ao Vivo</SubTitle>
</AdditionalTitle>
<Contributor SequenceNumber="1">
<ContributorPartyReference>P1</ContributorPartyReference>
<Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="MainArtist">UserDefined</Role>
</Contributor>
<CLine IsDefault="true">
<Year>2002</Year>
<CLineCompany>Universal Music International</CLineCompany>
<CLineText>© 2002 Universal Music International</CLineText>
</CLine>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<TechnicalDetails>
<TechnicalResourceDetailsReference>T1</TechnicalResourceDetailsReference>
<ImageCodecType>JPEG</ImageCodecType>
<ImageHeight UnitOfMeasure="Pixel">1408</ImageHeight>
<ImageWidth UnitOfMeasure="Pixel">1422</ImageWidth>
<File>
<URI>06UMGIM33173_T1_cvrart.jpg</URI>
<HashSum>
<Algorithm>MD5</Algorithm>
<HashSumValue>f6b0cdeaff97c8c438f940a12f3060c3</HashSumValue>
</HashSum>
</File>
</TechnicalDetails>
</Image>
</ResourceList>
<ReleaseList>
<Release>
<ReleaseReference>R0</ReleaseReference>
<ReleaseType>Album</ReleaseType>
<ReleaseId>
<ICPN>00044006704722</ICPN>
</ReleaseId>
<DisplayTitleText IsDefault="true">Ao Vivo No Maracanã</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Ao Vivo No Maracanã</TitleText>
<SubTitle>Ao Vivo</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Ao Vivo No Maracanã</TitleText>
<SubTitle>Ao Vivo</SubTitle>
</AdditionalTitle>
<DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName>
<DisplayArtist SequenceNumber="1">
<ArtistPartyReference>P1</ArtistPartyReference>
<DisplayArtistRole>MainArtist</DisplayArtistRole>
</DisplayArtist>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<PLine IsDefault="true">
<Year>2002</Year>
<PLineCompany>Universal Music Ltda</PLineCompany>
<PLineText>℗ 2002 Universal Music Ltda</PLineText>
</PLine>
<CLine IsDefault="true">
<Year>2002</Year>
<CLineCompany>Universal Music Ltda</CLineCompany>
<CLineText>© 2002 Universal Music Ltda</CLineText>
</CLine>
<Duration>PT59M47S</Duration>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
<ReleaseDate IsDefault="true">2006-03-07</ReleaseDate>
<OriginalReleaseDate IsDefault="true">2002-01-01</OriginalReleaseDate>
<ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType>
<IsMultiArtistCompilation>false</IsMultiArtistCompilation>
<ResourceGroup>
<ResourceGroup ResourceGroupType="Component">
<SequenceNumber>1</SequenceNumber>
<ResourceGroupContentItem>
<SequenceNumber>1</SequenceNumber>
<ReleaseResourceReference>A1</ReleaseResourceReference>
<IsInstantGratificationResource>false</IsInstantGratificationResource>
<IsPreOrderIncentiveResource>false</IsPreOrderIncentiveResource>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>2</SequenceNumber>
<ReleaseResourceReference>A2</ReleaseResourceReference>
<IsInstantGratificationResource>false</IsInstantGratificationResource>
<IsPreOrderIncentiveResource>false</IsPreOrderIncentiveResource>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>3</SequenceNumber>
<ReleaseResourceReference>A3</ReleaseResourceReference>
<IsInstantGratificationResource>false</IsInstantGratificationResource>
<IsPreOrderIncentiveResource>false</IsPreOrderIncentiveResource>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>4</SequenceNumber>
<ReleaseResourceReference>A4</ReleaseResourceReference>
<IsInstantGratificationResource>false</IsInstantGratificationResource>
<IsPreOrderIncentiveResource>false</IsPreOrderIncentiveResource>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>5</SequenceNumber>
<ReleaseResourceReference>A5</ReleaseResourceReference>
<IsInstantGratificationResource>false</IsInstantGratificationResource>
<IsPreOrderIncentiveResource>false</IsPreOrderIncentiveResource>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>6</SequenceNumber>
<ReleaseResourceReference>A6</ReleaseResourceReference>
<IsInstantGratificationResource>false</IsInstantGratificationResource>
<IsPreOrderIncentiveResource>false</IsPreOrderIncentiveResource>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>7</SequenceNumber>
<ReleaseResourceReference>A7</ReleaseResourceReference>
<IsInstantGratificationResource>false</IsInstantGratificationResource>
<IsPreOrderIncentiveResource>false</IsPreOrderIncentiveResource>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>8</SequenceNumber>
<ReleaseResourceReference>A8</ReleaseResourceReference>
<IsInstantGratificationResource>false</IsInstantGratificationResource>
<IsPreOrderIncentiveResource>false</IsPreOrderIncentiveResource>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>9</SequenceNumber>
<ReleaseResourceReference>A9</ReleaseResourceReference>
<IsInstantGratificationResource>false</IsInstantGratificationResource>
<IsPreOrderIncentiveResource>false</IsPreOrderIncentiveResource>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>10</SequenceNumber>
<ReleaseResourceReference>A10</ReleaseResourceReference>
<IsInstantGratificationResource>false</IsInstantGratificationResource>
<IsPreOrderIncentiveResource>false</IsPreOrderIncentiveResource>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>11</SequenceNumber>
<ReleaseResourceReference>A11</ReleaseResourceReference>
<IsInstantGratificationResource>false</IsInstantGratificationResource>
<IsPreOrderIncentiveResource>false</IsPreOrderIncentiveResource>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>12</SequenceNumber>
<ReleaseResourceReference>A12</ReleaseResourceReference>
<IsInstantGratificationResource>false</IsInstantGratificationResource>
<IsPreOrderIncentiveResource>false</IsPreOrderIncentiveResource>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>13</SequenceNumber>
<ReleaseResourceReference>A13</ReleaseResourceReference>
<IsInstantGratificationResource>false</IsInstantGratificationResource>
<IsPreOrderIncentiveResource>false</IsPreOrderIncentiveResource>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>14</SequenceNumber>
<ReleaseResourceReference>A14</ReleaseResourceReference>
<IsInstantGratificationResource>false</IsInstantGratificationResource>
<IsPreOrderIncentiveResource>false</IsPreOrderIncentiveResource>
</ResourceGroupContentItem>
</ResourceGroup>
<LinkedReleaseResourceReference>A15</LinkedReleaseResourceReference>
</ResourceGroup>
</Release>
<TrackRelease>
<ReleaseReference>R1</ReleaseReference>
<ReleaseId>
<ISRC>BRMCA0200733</ISRC>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">00044006704722_BRMCA0200733_R1</ProprietaryId>
</ReleaseId>
<DisplayTitleText IsDefault="true">Não Dá Pra Não Pensar</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Não Dá Pra Não Pensar</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Não Dá Pra Não Pensar</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<ReleaseResourceReference>A1</ReleaseResourceReference>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
</TrackRelease>
<TrackRelease>
<ReleaseReference>R2</ReleaseReference>
<ReleaseId>
<ISRC>BRMCA0200734</ISRC>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">00044006704722_BRMCA0200734_R2</ProprietaryId>
</ReleaseId>
<DisplayTitleText IsDefault="true">Nada É Por Acaso</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Nada É Por Acaso</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Nada É Por Acaso</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<ReleaseResourceReference>A2</ReleaseResourceReference>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
</TrackRelease>
<TrackRelease>
<ReleaseReference>R3</ReleaseReference>
<ReleaseId>
<ISRC>BRMCA0200724</ISRC>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">00044006704722_BRMCA0200724_R3</ProprietaryId>
</ReleaseId>
<DisplayTitleText IsDefault="true">Super-Herói (Não É Fácil)</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Super-Herói (Não É Fácil)</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Super-Herói (Não É Fácil)</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<ReleaseResourceReference>A3</ReleaseResourceReference>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
</TrackRelease>
<TrackRelease>
<ReleaseReference>R4</ReleaseReference>
<ReleaseId>
<ISRC>BRMCA0200744</ISRC>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">00044006704722_BRMCA0200744_R4</ProprietaryId>
</ReleaseId>
<DisplayTitleText IsDefault="true">Deixa Eu Tentar</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Deixa Eu Tentar</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Deixa Eu Tentar</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<ReleaseResourceReference>A4</ReleaseResourceReference>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
</TrackRelease>
<TrackRelease>
<ReleaseReference>R5</ReleaseReference>
<ReleaseId>
<ISRC>BRMCA0200735</ISRC>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">00044006704722_BRMCA0200735_R5</ProprietaryId>
</ReleaseId>
<DisplayTitleText IsDefault="true">Quando Você Passa (Turu Turu)</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Quando Você Passa (Turu Turu)</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Quando Você Passa (Turu Turu)</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<ReleaseResourceReference>A5</ReleaseResourceReference>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
</TrackRelease>
<TrackRelease>
<ReleaseReference>R6</ReleaseReference>
<ReleaseId>
<ISRC>BRMCA0200743</ISRC>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">00044006704722_BRMCA0200743_R6</ProprietaryId>
</ReleaseId>
<DisplayTitleText IsDefault="true">Uninvited</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Uninvited</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Uninvited</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<ReleaseResourceReference>A6</ReleaseResourceReference>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
</TrackRelease>
<TrackRelease>
<ReleaseReference>R7</ReleaseReference>
<ReleaseId>
<ISRC>BRMCA0200725</ISRC>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">00044006704722_BRMCA0200725_R7</ProprietaryId>
</ReleaseId>
<DisplayTitleText IsDefault="true">Como É Grande O Meu Amor Por Você</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Como É Grande O Meu Amor Por Você</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Como É Grande O Meu Amor Por Você</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<ReleaseResourceReference>A7</ReleaseResourceReference>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
</TrackRelease>
<TrackRelease>
<ReleaseReference>R8</ReleaseReference>
<ReleaseId>
<ISRC>BRMCA0200736</ISRC>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">00044006704722_BRMCA0200736_R8</ProprietaryId>
</ReleaseId>
<DisplayTitleText IsDefault="true">Enrosca</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Enrosca</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Enrosca</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<ReleaseResourceReference>A8</ReleaseResourceReference>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
</TrackRelease>
<TrackRelease>
<ReleaseReference>R9</ReleaseReference>
<ReleaseId>
<ISRC>BRMCA0200737</ISRC>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">00044006704722_BRMCA0200737_R9</ProprietaryId>
</ReleaseId>
<DisplayTitleText IsDefault="true">A Lenda</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>A Lenda</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>A Lenda</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<ReleaseResourceReference>A9</ReleaseResourceReference>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
</TrackRelease>
<TrackRelease>
<ReleaseReference>R10</ReleaseReference>
<ReleaseId>
<ISRC>BRMCA0200738</ISRC>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">00044006704722_BRMCA0200738_R10</ProprietaryId>
</ReleaseId>
<DisplayTitleText IsDefault="true">Words Are Not Enough</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Words Are Not Enough</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Words Are Not Enough</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<ReleaseResourceReference>A10</ReleaseResourceReference>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
</TrackRelease>
<TrackRelease>
<ReleaseReference>R11</ReleaseReference>
<ReleaseId>
<ISRC>BRMCA0200739</ISRC>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">00044006704722_BRMCA0200739_R11</ProprietaryId>
</ReleaseId>
<DisplayTitleText IsDefault="true">Love Never Fails</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Love Never Fails</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Love Never Fails</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<ReleaseResourceReference>A11</ReleaseResourceReference>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
</TrackRelease>
<TrackRelease>
<ReleaseReference>R12</ReleaseReference>
<ReleaseId>
<ISRC>BRMCA0200740</ISRC>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">00044006704722_BRMCA0200740_R12</ProprietaryId>
</ReleaseId>
<DisplayTitleText IsDefault="true">O Amor Faz</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>O Amor Faz</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>O Amor Faz</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<ReleaseResourceReference>A12</ReleaseResourceReference>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
</TrackRelease>
<TrackRelease>
<ReleaseReference>R13</ReleaseReference>
<ReleaseId>
<ISRC>BRMCA0200741</ISRC>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">00044006704722_BRMCA0200741_R13</ProprietaryId>
</ReleaseId>
<DisplayTitleText IsDefault="true">A Gente Dá Certo</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>A Gente Dá Certo</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>A Gente Dá Certo</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<ReleaseResourceReference>A13</ReleaseResourceReference>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
</TrackRelease>
<TrackRelease>
<ReleaseReference>R14</ReleaseReference>
<ReleaseId>
<ISRC>BRMCA0200742</ISRC>
<ProprietaryId Namespace="DPID:PADPIDA2013042401U">00044006704722_BRMCA0200742_R14</ProprietaryId>
</ReleaseId>
<DisplayTitleText IsDefault="true">Cai A Chuva / Me Diz / Citação: Não Posso Mais</DisplayTitleText>
<DisplayTitle IsDefault="true">
<TitleText>Cai A Chuva / Me Diz / Citação: Não Posso Mais</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</DisplayTitle>
<AdditionalTitle IsDefault="true" TitleType="FormalTitle">
<TitleText>Cai A Chuva / Me Diz / Citação: Não Posso Mais</TitleText>
<SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle>
</AdditionalTitle>
<ReleaseResourceReference>A14</ReleaseResourceReference>
<ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference>
<Genre IsDefault="true">
<GenreText>Pop</GenreText>
</Genre>
</TrackRelease>
</ReleaseList>
<DealList>
<ReleaseDeal>
<DealReleaseReference>R0</DealReleaseReference>
<Deal>
<DealTerms>
<TerritoryCode>CA</TerritoryCode>
<ValidityPeriod>
<StartDate>2007-09-18</StartDate>
</ValidityPeriod>
<CommercialModelType>SubscriptionModel</CommercialModelType>
<UseType>ConditionalDownload</UseType>
<ReleaseDisplayStartDate>2007-09-18</ReleaseDisplayStartDate>
<TrackListingPreviewStartDate>2007-09-18</TrackListingPreviewStartDate>
<CoverArtPreviewStartDate>2007-09-18</CoverArtPreviewStartDate>
<ClipPreviewStartDate>2007-09-18</ClipPreviewStartDate>
</DealTerms>
</Deal>
<Deal>
<DealTerms>
<TerritoryCode>US</TerritoryCode>
<ValidityPeriod>
<StartDate>2007-11-27</StartDate>
</ValidityPeriod>
<CommercialModelType>SubscriptionModel</CommercialModelType>
<UseType>ConditionalDownload</UseType>
<ReleaseDisplayStartDate>2007-11-27</ReleaseDisplayStartDate>
<TrackListingPreviewStartDate>2007-11-27</TrackListingPreviewStartDate>
<CoverArtPreviewStartDate>2007-11-27</CoverArtPreviewStartDate>
<ClipPreviewStartDate>2007-11-27</ClipPreviewStartDate>
</DealTerms>
</Deal>
</ReleaseDeal>
<ReleaseDeal>
<DealReleaseReference>R1</DealReleaseReference>
<DealReleaseReference>R2</DealReleaseReference>
<DealReleaseReference>R3</DealReleaseReference>
<DealReleaseReference>R4</DealReleaseReference>
<DealReleaseReference>R5</DealReleaseReference>
<DealReleaseReference>R6</DealReleaseReference>
<DealReleaseReference>R7</DealReleaseReference>
<DealReleaseReference>R8</DealReleaseReference>
<DealReleaseReference>R9</DealReleaseReference>
<DealReleaseReference>R10</DealReleaseReference>
<DealReleaseReference>R11</DealReleaseReference>
<DealReleaseReference>R12</DealReleaseReference>
<DealReleaseReference>R13</DealReleaseReference>
<DealReleaseReference>R14</DealReleaseReference>
<Deal>
<DealTerms>
<TerritoryCode>CA</TerritoryCode>
<ValidityPeriod>
<StartDate>2007-09-18</StartDate>
</ValidityPeriod>
<CommercialModelType>SubscriptionModel</CommercialModelType>
<UseType>ConditionalDownload</UseType>
<UseType>Stream</UseType>
<ReleaseDisplayStartDate>2007-09-18</ReleaseDisplayStartDate>
<TrackListingPreviewStartDate>2007-09-18</TrackListingPreviewStartDate>
<CoverArtPreviewStartDate>2007-09-18</CoverArtPreviewStartDate>
<ClipPreviewStartDate>2007-09-18</ClipPreviewStartDate>
</DealTerms>
</Deal>
<Deal>
<DealTerms>
<TerritoryCode>US</TerritoryCode>
<ValidityPeriod>
<StartDate>2007-11-27</StartDate>
</ValidityPeriod>
<CommercialModelType>SubscriptionModel</CommercialModelType>
<UseType>ConditionalDownload</UseType>
<UseType>Stream</UseType>
<ReleaseDisplayStartDate>2007-11-27</ReleaseDisplayStartDate>
<TrackListingPreviewStartDate>2007-11-27</TrackListingPreviewStartDate>
<CoverArtPreviewStartDate>2007-11-27</CoverArtPreviewStartDate>
<ClipPreviewStartDate>2007-11-27</ClipPreviewStartDate>
</DealTerms>
</Deal>
</ReleaseDeal>
</DealList>
</ernm:NewReleaseMessage>

On Fri, Aug 21, 2020 at 2:38 PM Christian Grün <christian.gruen@gmail.com> wrote:

Just a quick hint: As the query info output indicates that no text
index is used (see [1]), you could try to attach explicit text() steps
in your comparisons:

where $track_release/ReleaseLabelReference/text() =
$r/PartyList/Party/PartyReference/text()
...
where $track_release/ReleaseResourceReference/text() =
$sound_recording/ResourceReference/text()
...

Feel free to provide us with a minimized XML document that allows us
to run your query.

[1] https://docs.basex.org/wiki/Indexes

On Fri, Aug 21, 2020 at 11:26 PM Bill Osmond <bill@with.in> wrote:
>
> The indentation levels and multiple returns in your suggested query alone has helped me in understanding what's actually going on, and I've rewritten the query mostly as you suggest:
>
> for $r in /ernm:NewReleaseMessage
> for $track_release in $r/ReleaseList/TrackRelease
> where $track_release/ReleaseLabelReference = $r/PartyList/Party/PartyReference
> return
> for $party in $r/PartyList/Party
> for $sound_recording in $r/ResourceList/SoundRecording
> where $track_release/ReleaseResourceReference = $sound_recording/ResourceReference
> return
> for $release in $r/ReleaseList/Release
> where $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference
> 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>
>
> I say "mostly" because at the first 'where' statement, I had to replace the $party/PartyReference on the right side of the = with an explicit reference from $r, because $party isn't defined until 2 lines further down. The query does work and appears to be giving the right results, however the performance is basically the same: 127,698.27 ms for this run vs. 114,935.22 ms for the original. I'll try shuffling things around next!
>
> On Fri, Aug 21, 2020 at 1:52 PM Bill Osmond <bill@with.in> wrote:
>>
>> Thank you both! I was in the middle of typing a response to Bridger when this came through, so while I digest both of your messages & test index addition/moving things around, I'll leave the output from the GUI info panel here - if I knew how to read it, it would no doubt point straight at the issue! I'll note that it runs much quicker locally as opposed to on server+via the python BaseXClient, but I don't know if that's because the GUI is stopping at 500k results, or what.
>>
>> Compiling:
>> - rewrite context value to document-node() sequence: . -> (db:open-pre("umg-118061851424", 0), ...)
>> - rewrite util:root(nodes) to document-node() sequence: util:root((db:open-pre("umg-118061851424", 0), ...)) -> (db:open-pre("umg-118061851424", 0), ...)
>> - move where clause: $track_release_1/ReleaseLabelReference = $party_2/PartyReference
>> - swap operands: PartyReference = $track_release_1/ReleaseLabelReference
>> - rewrite to predicate: PartyReference = $track_release_1/ReleaseLabelReference
>> - move where clause: $track_release_1/ReleaseResourceReference = $sound_recording_3/ResourceReference
>> - swap operands: ResourceReference = $track_release_1/ReleaseResourceReference
>> - rewrite to predicate: ResourceReference = $track_release_1/ReleaseResourceReference
>> - swap operands: ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference = $track_release_1/Rel...
>> - rewrite to predicate: ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference = $track_release_1/Rel...
>> - inline for $release_4 in $r_0/ReleaseList/Release[ResourceGroup/ResourceGroup/ResourceGroupContentItem/Rele...
>>
>> Optimized Query:
>> for $r_0 in (db:open-pre("umg-118061851424", 0), ...)/ernm:NewReleaseMessage for $track_release_1 in $r_0/ReleaseList/TrackRelease for $party_2 in $r_0/PartyList/Party[PartyReference = $track_release_1/ReleaseLabelReference] for $sound_recording_3 in $r_0/ResourceList/SoundRecording[ResourceReference = $track_release_1/ReleaseResourceReference] return $r_0/ReleaseList/Release[ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference = $track_release_1/ReleaseResourceReference] ! <identity> <isrc> { $track_release_1/ReleaseId/ISRC/text() } </isrc> <artist> { string-join($sound_recording_3/DisplayArtistName, "/") } </artist> <title> { $sound_recording_3/DisplayTitleText/text() } </title> <album> { DisplayTitleText/text() } </album> <icpn> { ReleaseId/ICPN/text() } </icpn> <sublabel> { $party_2/PartyName/FullName/text() } </sublabel> </identity>
>>
>> Query:
>> declare namespace ernm="http://ddex.net/xml/ern/411"; for $r in /ernm:NewReleaseMessage for $track_release in $r/ReleaseList/TrackRelease for $party in $r/PartyList/Party for $sound_recording in $r/ResourceList/SoundRecording for $release in $r/ReleaseList/Release where $track_release/ReleaseLabelReference = $party/PartyReference and $track_release/ReleaseResourceReference = $sound_recording/ResourceReference and $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference 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>
>>
>> Result:
>> - Hit(s): 500000 Items
>> - Updated: 0 Items
>> - Printed: 8192 kB
>> - Read Locking: umg-118061851424
>> - Write Locking: (none)
>>
>> Timing:
>> - Parsing: 2.88 ms
>> - Compiling: 4.38 ms
>> - Evaluating: 114935.22 ms
>> - Printing: 114.59 ms
>> - Total Time: 115057.07 ms
>>
>> Query Plan:
>> <QueryPlan compiled="true" updating="false">
>> <GFLWOR type="element()*">
>> <For type="element()" size="1" name="$r" id="0">
>> <IterPath type="element()*" database="umg-118061851424">
>> <DBNodeSeq type="document-node()+" size="136938" database="umg-118061851424">
>> <DBNode pre="0" type="document-node()" size="1" database="umg-118061851424"/>
>> <DBNode pre="59" type="document-node()" size="1" database="umg-118061851424"/>
>> <DBNode pre="118" type="document-node()" size="1" database="umg-118061851424"/>
>> <DBNode pre="177" type="document-node()" size="1" database="umg-118061851424"/>
>> <DBNode pre="236" type="document-node()" size="1" database="umg-118061851424"/>
>> </DBNodeSeq>
>> <IterStep axis="child" test="ernm:NewReleaseMessage" type="element()*"/>
>> </IterPath>
>> </For>
>> <For type="element()" size="1" name="$track_release" id="1">
>> <IterPath type="element()*" database="umg-118061851424">
>> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/>
>> <IterStep axis="child" test="ReleaseList" type="element()*"/>
>> <IterStep axis="child" test="TrackRelease" type="element()*"/>
>> </IterPath>
>> </For>
>> <For type="element()" size="1" name="$party" id="2">
>> <IterPath type="element()*" database="umg-118061851424">
>> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/>
>> <IterStep axis="child" test="PartyList" type="element()*"/>
>> <IterStep axis="child" test="Party" type="element()*">
>> <CmpHashG op="=" type="xs:boolean" size="1">
>> <SingleIterPath type="element()*" database="umg-118061851424">
>> <IterStep axis="child" test="PartyReference" type="element()*"/>
>> </SingleIterPath>
>> <IterPath type="element()*" database="umg-118061851424">
>> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/>
>> <IterStep axis="child" test="ReleaseLabelReference" type="element()*"/>
>> </IterPath>
>> </CmpHashG>
>> </IterStep>
>> </IterPath>
>> </For>
>> <For type="element()" size="1" name="$sound_recording" id="3">
>> <IterPath type="element()*" database="umg-118061851424">
>> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/>
>> <IterStep axis="child" test="ResourceList" type="element()*"/>
>> <IterStep axis="child" test="SoundRecording" type="element()*">
>> <CmpHashG op="=" type="xs:boolean" size="1">
>> <SingleIterPath type="element()*" database="umg-118061851424">
>> <IterStep axis="child" test="ResourceReference" type="element()*"/>
>> </SingleIterPath>
>> <IterPath type="element()*" database="umg-118061851424">
>> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/>
>> <IterStep axis="child" test="ReleaseResourceReference" type="element()*"/>
>> </IterPath>
>> </CmpHashG>
>> </IterStep>
>> </IterPath>
>> </For>
>> <DualMap type="element()*">
>> <IterPath type="element()*" database="umg-118061851424">
>> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/>
>> <IterStep axis="child" test="ReleaseList" type="element()*"/>
>> <IterStep axis="child" test="Release" type="element()*">
>> <CmpHashG op="=" type="xs:boolean" size="1">
>> <IterPath type="element()*" database="umg-118061851424">
>> <IterStep axis="child" test="ResourceGroup" type="element()*"/>
>> <IterStep axis="child" test="ResourceGroup" type="element()*"/>
>> <IterStep axis="child" test="ResourceGroupContentItem" type="element()*"/>
>> <IterStep axis="child" test="ReleaseResourceReference" type="element()*"/>
>> </IterPath>
>> <IterPath type="element()*" database="umg-118061851424">
>> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/>
>> <IterStep axis="child" test="ReleaseResourceReference" type="element()*"/>
>> </IterPath>
>> </CmpHashG>
>> </IterStep>
>> </IterPath>
>> <CElem type="element()" size="1">
>> <QNm type="xs:QName" size="1">identity</QNm>
>> <CElem type="element()" size="1">
>> <QNm type="xs:QName" size="1">isrc</QNm>
>> <IterPath type="text()*" database="umg-118061851424">
>> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/>
>> <IterStep axis="child" test="ReleaseId" type="element()*"/>
>> <IterStep axis="child" test="ISRC" type="element()*"/>
>> <IterStep axis="child" test="text()" type="text()*"/>
>> </IterPath>
>> </CElem>
>> <CElem type="element()" size="1">
>> <QNm type="xs:QName" size="1">artist</QNm>
>> <FnStringJoin name="string-join" type="xs:string" size="1">
>> <IterPath type="element()*" database="umg-118061851424">
>> <VarRef type="element()" size="1" database="umg-118061851424" name="$sound_recording" id="3"/>
>> <IterStep axis="child" test="DisplayArtistName" type="element()*"/>
>> </IterPath>
>> <Str type="xs:string" size="1">/</Str>
>> </FnStringJoin>
>> </CElem>
>> <CElem type="element()" size="1">
>> <QNm type="xs:QName" size="1">title</QNm>
>> <IterPath type="text()*" database="umg-118061851424">
>> <VarRef type="element()" size="1" database="umg-118061851424" name="$sound_recording" id="3"/>
>> <IterStep axis="child" test="DisplayTitleText" type="element()*"/>
>> <IterStep axis="child" test="text()" type="text()*"/>
>> </IterPath>
>> </CElem>
>> <CElem type="element()" size="1">
>> <QNm type="xs:QName" size="1">album</QNm>
>> <IterPath type="text()*" database="umg-118061851424">
>> <IterStep axis="child" test="DisplayTitleText" type="element()*"/>
>> <IterStep axis="child" test="text()" type="text()*"/>
>> </IterPath>
>> </CElem>
>> <CElem type="element()" size="1">
>> <QNm type="xs:QName" size="1">icpn</QNm>
>> <IterPath type="text()*" database="umg-118061851424">
>> <IterStep axis="child" test="ReleaseId" type="element()*"/>
>> <IterStep axis="child" test="ICPN" type="element()*"/>
>> <IterStep axis="child" test="text()" type="text()*"/>
>> </IterPath>
>> </CElem>
>> <CElem type="element()" size="1">
>> <QNm type="xs:QName" size="1">sublabel</QNm>
>> <IterPath type="text()*" database="umg-118061851424">
>> <VarRef type="element()" size="1" database="umg-118061851424" name="$party" id="2"/>
>> <IterStep axis="child" test="PartyName" type="element()*"/>
>> <IterStep axis="child" test="FullName" type="element()*"/>
>> <IterStep axis="child" test="text()" type="text()*"/>
>> </IterPath>
>> </CElem>
>> </CElem>
>> </DualMap>
>> </GFLWOR>
>> </QueryPlan>
>>
>> On Fri, Aug 21, 2020 at 1:48 PM Liam R. E. Quin <liam@fromoldbooks.org> wrote:
>>>
>>> On Fri, 2020-08-21 at 12:51 -0700, Bill Osmond wrote:
>>> >
>>> > declare namespace ernm="http://ddex.net/xml/ern/411";
>>> >
>>> > for $r in /ernm:NewReleaseMessage
>>> > for $track_release in $r/ReleaseList/TrackRelease
>>> > for $party in $r/PartyList/Party
>>> > for $sound_recording in $r/ResourceList/SoundRecording
>>> > for $release in $r/ReleaseList/Release
>>> > where
>>> > $track_release/ReleaseLabelReference = $party/PartyReference
>>> > and $track_release/ReleaseResourceReference =
>>> > $sound_recording/ResourceReference
>>> > and $track_release/ReleaseResourceReference =
>>> > $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/Release
>>> > ResourceReference
>>>
>>> BaseX is probably smart enough to rewrite this, but check -
>>>
>>> for $r in /ernm:NewReleaseMessage
>>> for $track_release in $r/ReleaseList/TrackRelease
>>> where $track_release/ReleaseLabelReference = $party/PartyReference
>>>
>>> return
>>> for $party in $r/PartyList/Party
>>> for $sound_recording in $r/ResourceList/SoundRecording
>>> where $track_release/ReleaseResourceReference =
>>> $sound_recording/ResourceReference
>>> return
>>> for $release in $r/ReleaseList/Release
>>> where
>>> $track_release/ReleaseResourceReference =
>>> $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseRe
>>> sourceReference
>>> return
>>> <identity>...
>>>
>>> > Am I wrong, and would an additional value index help here? Or is my
>>> > query
>>> > just bad?
>>>
>>> You're computing every possible combiation of 5 items and then
>>> filtering out the ones you want.
>>>
>>> Filtering out earlier would probably help. Also, moving the tests least
>>> lilely to match to the outside would reduce the number of tests sooner.
>>>
>>> A value index might well help, but as Bridger wrote, check in the gUI
>>> to see the query plan. BaseX might already be doing the sort of rewrite
>>> i suggested.
>>>
>>> Liam
>>>
>>>
>>> --
>>> Liam Quin, https://www.delightfulcomputing.com/
>>> Available for XML/Document/Information Architecture/XSLT/
>>> XSL/XQuery/Web/Text Processing/A11Y training, work & consulting.
>>> Barefoot Web-slave, antique illustrations: http://www.fromoldbooks.org
>>>
>>
>