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 = 453067398 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '4/26/2016' OR (SongInfo.ShowDate = '4/26/2016' AND SongInfo.ShowID < 453067398)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
280 | 1 | 9/30/1992 12:00:00 AM | 453055714 | DMB | 8609 | 56 |
280 | 3 | 2/26/2007 12:00:00 AM | 453056400 | Dave & Tim | 3347 | 91 |
280 | 6 | 1/30/2016 12:00:00 AM | 453065439 | 123 Go! | 87 | 1154 |
280 | 12 | 7/3/1993 12:00:00 AM | 453089752 | C-ville Allstars | 8333 | 53 |
280 | 20 | 5/6/2001 12:00:00 AM | 453056944 | Jazzfest Superjam | 5469 | 1 |
280 | 10129 | 8/16/2012 12:00:00 AM | 453080553 | Boyd & Joe Lawlor | 1349 | 116 |
4867 | 2051 | 4/12/2016 12:00:00 AM | 453067394 | Crystal Garden | 14 | 2155 |