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 = 453055856 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '5/10/2002' OR (SongInfo.ShowDate = '5/10/2002' AND SongInfo.ShowID < 453055856)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
76 | 1 | 5/7/2002 12:00:00 AM | 453055772 | DMB | 3 | 12 |
76 | 2 | 3/16/2002 12:00:00 AM | 453055784 | Dave solo | 55 | 32 |
76 | 49 | 2/28/2001 12:00:00 AM | 453063291 | Trey Anastasio Band | 436 | 1140 |
90 | 1 | 5/10/2002 12:00:00 AM | 453055774 | DMB | 0 | 12 |
90 | 2 | 3/16/2002 12:00:00 AM | 453055784 | Dave solo | 55 | 32 |
109 | 1 | 5/9/2002 12:00:00 AM | 453055773 | DMB | 1 | 12 |
109 | 2 | 11/12/2001 12:00:00 AM | 61 | Dave solo | 179 | 1 |
109 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | 810 | 15 |