HOME    SONG   ARTIST   COLLECTION    CHART     YEAR        Misc   A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z       Misc   A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z       Misc   A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z       Debut Date        Peak Date        Peak Position    KCIX Music Search     Loading Data...    Song Artist Collection  Exact:

CDs:  2275 LPs:  253 12" Singles:  629 7" Singles:  901 MP3s:  8336 TOTAL SONGS:  32176

There was a problem opening the record set: The connection cannot be used to perform this operation. It is either closed or invalid in this context. SELECT DISTINCT Song.SongID, Song.Song, Song.LyricsURL, Artist.ArtistID, Artist.The, Artist.Artist, Version.*, yyVersionName.Version, Year.Year, Year.Chart, Format(Year.ChartDate, "mm/dd/yyyy") AS ChartDate, Format(Year.PeakDate, "mm/dd/yyyy") AS PeakDate, Year.ChartWeeks, Year.Top40Weeks, Year.Top10Weeks, Year.PeakWeeks, Year.FirstChartingSong, Year.OnlyChartingSong, Collection.CollectionID, Collection.Collection, yyFormat.Format, yyChartType.ChartType FROM (((((((Version RIGHT JOIN (((Song LEFT JOIN xxSongArtist ON Song.SongID = xxSongArtist.SongID) LEFT JOIN Artist ON xxSongArtist.ArtistID = Artist.ArtistID) LEFT JOIN xxSongVersion ON Song.SongID = xxSongVersion.SongID) ON Version.VersionID = xxSongVersion.VersionID) LEFT JOIN xxVersionYear ON Version.VersionID = xxVersionYear.VersionID) LEFT JOIN [Year] ON xxVersionYear.YearID = Year.YearID) LEFT JOIN yyVersionName ON Version.VersionNameID = yyVersionName.VersionNameID) LEFT JOIN xxVersionCollection ON Version.VersionID = xxVersionCollection.VersionID) LEFT JOIN Collection ON xxVersionCollection.CollectionID = Collection.CollectionID) LEFT JOIN yyFormat ON Collection.FormatID = yyFormat.FormatID) LEFT JOIN yyChartType ON Year.ChartTypeID = yyChartType.ChartTypeID WHERE Song.SongID = 18527 AND Collection.InLibrary = True ORDER BY Song, Artist, Year, Version, Collection;