SELECT SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate, SongInfo.ShowID, ShowArtists.ShortName, DATEDIFF (D, SongInfo.ShowDate, ThisShow.ShowDate) NumDays, ShowInfo.TourID FROM SongInfo INNER JOIN SongInfo ThisShow ON ThisShow.SongID = SongInfo.SongID AND ThisShow.ShowID = 453057207 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '10/10/2014' OR (SongInfo.ShowDate = '10/10/2014' AND SongInfo.ShowID < 453057207)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
723 | 1 | 9/6/2014 12:00:00 AM | 453057191 | DMB | 34 | 125 |
723 | 2 | 4/3/2014 12:00:00 AM | 453057198 | Dave solo | 190 | 122 |
723 | 3 | 1/16/2014 12:00:00 AM | 453057149 | Dave & Tim | 267 | 122 |
723 | 1024 | 9/4/2014 12:00:00 AM | 453057206 | Dave, Tim & Rashawn | 36 | 122 |
781 | 1 | 9/6/2014 12:00:00 AM | 453057191 | DMB | 34 | 125 |