Let say this is the format I used; <Track #>. <Title> (<Artist>)
01. Monkey (Smile;Flower)
02. Bird (Cat;Cow)
03. Smoke (Smile)
What I want is, the Album Artist to appear like this; (Smile;Flower;Cat;Cow), since Track #1 Smile is the first singer.
The reason for this is, I don't use something like;
01. Monkey feat. Flower (Smile)
Since Smile is the main 'star' of this Album, naturally he/she would be the first person on Album Artist; everyone else is just support, guest star, or less significant.
My Auto-organizing format is as follow;
\$First<Album Artist>\<Album>\<Track #>. <Title>
As you can see in the '$First<Album Artist>', this should create a folder for Smile, not Flower/Cat or Cow. They not important as Smile.
Hope that more understandable. Thank you for your time and help.
ZvezdanD wrote: I don't know what you mean by "Appearance". If you want to get artists ordered by Track #, then you could use this Replace with string:
Code: Select all
SQLQuery("SELECT group_concat(AA, '; ') FROM (SELECT DISTINCT Artists.Artist AS AA FROM Songs INNER JOIN ArtistsSongs ON Songs.ID = ArtistsSongs.IDSong AND (ArtistsSongs.PersonType = 1 OR ArtistsSongs.PersonType IS NULL) INNER JOIN Artists ON ArtistsSongs.IDArtist = Artists.ID WHERE IDAlbum = " & oSongData.Album.ID & " ORDER BY CAST(Songs.TrackNumber AS int))")