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 = 453055897 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '6/11/1999' OR (SongInfo.ShowDate = '6/11/1999' AND SongInfo.ShowID < 453055897)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
8 | 1 | 6/5/1999 12:00:00 AM | 453054638 | DMB | 6 | 17 |
8 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | 2464 | 57 |
8 | 3 | 3/13/1999 12:00:00 AM | 453054612 | Dave & Tim | 90 | 16 |
13 | 1 | 6/9/1999 12:00:00 AM | 453054640 | DMB | 2 | 17 |
13 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | 1153 | 31 |
13 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | 78 | 16 |
13 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | 1138 | 31 |
46 | 1 | 6/11/1999 12:00:00 AM | 453054642 | DMB | 0 | 17 |
46 | 2 | 3/24/1999 12:00:00 AM | 453055895 | Dave solo | 79 | 62 |
46 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | 78 | 16 |
46 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | 1138 | 31 |
46 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | 1393 | 41 |