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 = 453055903 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '9/21/2002' OR (SongInfo.ShowDate = '9/21/2002' AND SongInfo.ShowID < 453055903)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
20 | 1 | 9/7/2002 12:00:00 AM | 453055842 | DMB | 14 | 58 |
20 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | 2351 | 31 |
20 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | 1276 | 16 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | 2837 | 52 |
20 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | 2717 | 41 |
20 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | 13 | 32 |
47 | 1 | 9/8/2002 12:00:00 AM | 453055843 | DMB | 13 | 58 |
47 | 2 | 3/9/1999 12:00:00 AM | 453054608 | Dave solo | 1292 | 62 |
47 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | 1276 | 16 |
47 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | 2336 | 31 |
55 | 1 | 9/7/2002 12:00:00 AM | 453055842 | DMB | 14 | 58 |
55 | 2 | 11/12/2001 12:00:00 AM | 61 | Dave solo | 313 | 1 |
55 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | 1276 | 16 |
65 | 1 | 9/6/2002 12:00:00 AM | 453055841 | DMB | 15 | 58 |
65 | 2 | 11/13/2001 12:00:00 AM | 62 | Dave solo | 312 | 1 |
65 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | 1276 | 16 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | 944 | 15 |
70 | 1 | 9/8/2002 12:00:00 AM | 453055843 | DMB | 13 | 58 |
70 | 2 | 8/26/2002 12:00:00 AM | 453056020 | Dave solo | 26 | 66 |
90 | 1 | 9/7/2002 12:00:00 AM | 453055842 | DMB | 14 | 58 |
90 | 2 | 9/6/2002 12:00:00 AM | 453055883 | Dave solo | 15 | 66 |
96 | 1 | 9/8/2002 12:00:00 AM | 453055843 | DMB | 13 | 58 |
96 | 2 | 3/16/2002 12:00:00 AM | 453055784 | Dave solo | 189 | 32 |
96 | 3 | 3/14/1999 12:00:00 AM | 453054613 | Dave & Tim | 1287 | 16 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | 3452 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | 3515 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | 3075 | 1133 |
205 | 1 | 9/6/2002 12:00:00 AM | 453055841 | DMB | 15 | 58 |
205 | 2 | 8/29/2002 12:00:00 AM | 453055884 | Dave solo | 23 | 66 |
205 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | 13 | 32 |