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 = 453078475 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '12/10/2017' OR (SongInfo.ShowDate = '12/10/2017' AND SongInfo.ShowID < 453078475)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
55 | 1 | 9/3/2016 12:00:00 AM | 453065437 | DMB | 463 | 2154 |
55 | 2 | 10/2/2017 12:00:00 AM | 453076475 | Dave solo | 69 | 3154 |
55 | 3 | 9/16/2017 12:00:00 AM | 453072474 | Dave & Tim | 85 | 3154 |
55 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | 4775 | 79 |
55 | 1024 | 9/4/2014 12:00:00 AM | 453057206 | Dave, Tim & Rashawn | 1193 | 122 |
253 | 1 | 9/24/2017 12:00:00 AM | 453075474 | DMB | 77 | 3154 |
253 | 4 | 12/15/2003 12:00:00 AM | 453056047 | Dave & Friends | 5109 | 76 |