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 = 453054417 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '7/21/2000' OR (SongInfo.ShowDate = '7/21/2000' AND SongInfo.ShowID < 453054417)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
4 | 1 | 7/19/2000 12:00:00 AM | 453054416 | DMB | 2 | 13 |
4 | 2 | 5/21/1999 12:00:00 AM | 453055896 | Dave solo | 427 | 62 |
4 | 3 | 3/10/1999 12:00:00 AM | 453054610 | Dave & Tim | 499 | 16 |
10 | 1 | 7/15/2000 12:00:00 AM | 453054414 | DMB | 6 | 13 |
10 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | 1559 | 31 |
10 | 3 | 2/6/1999 12:00:00 AM | 453054586 | Dave & Tim | 531 | 16 |
10 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | 1799 | 41 |
12 | 1 | 7/15/2000 12:00:00 AM | 453054414 | DMB | 6 | 13 |
12 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | 1559 | 31 |
12 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | 484 | 16 |
13 | 1 | 7/19/2000 12:00:00 AM | 453054416 | DMB | 2 | 13 |
13 | 2 | 6/11/1999 12:00:00 AM | 453055897 | Dave solo | 406 | 62 |
13 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | 484 | 16 |
13 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | 1544 | 31 |
15 | 1 | 7/19/2000 12:00:00 AM | 453054416 | DMB | 2 | 13 |
15 | 12 | 1/12/1993 12:00:00 AM | 453055495 | C-ville Allstars | 2747 | 53 |
17 | 1 | 7/19/2000 12:00:00 AM | 453054416 | DMB | 2 | 13 |
17 | 2 | 3/8/1999 12:00:00 AM | 453054607 | Dave solo | 501 | 62 |
17 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | 484 | 16 |
21 | 1 | 7/16/2000 12:00:00 AM | 453054415 | DMB | 5 | 13 |
21 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | 1559 | 31 |
21 | 3 | 3/24/1999 12:00:00 AM | 453054614 | Dave & Tim | 485 | 18 |
22 | 1 | 7/19/2000 12:00:00 AM | 453054416 | DMB | 2 | 13 |
22 | 2 | 12/11/1998 12:00:00 AM | 453056392 | Dave solo | 588 | 34 |
22 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | 484 | 16 |
22 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | 2660 | 53 |
22 | 15 | 10/29/1994 12:00:00 AM | 453089864 | Dave & Boyd | 2092 | 63 |
28 | 1 | 7/19/2000 12:00:00 AM | 453054416 | DMB | 2 | 13 |
28 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | 1544 | 31 |
30 | 1 | 7/16/2000 12:00:00 AM | 453054415 | DMB | 5 | 13 |
30 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | 1559 | 31 |
30 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | 484 | 16 |
30 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | 2045 | 52 |
47 | 1 | 7/19/2000 12:00:00 AM | 453054416 | DMB | 2 | 13 |
47 | 2 | 3/9/1999 12:00:00 AM | 453054608 | Dave solo | 500 | 62 |
47 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | 484 | 16 |
47 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | 1544 | 31 |
59 | 1 | 7/19/2000 12:00:00 AM | 453054416 | DMB | 2 | 13 |
59 | 3 | 3/13/1999 12:00:00 AM | 453054612 | Dave & Tim | 496 | 16 |
63 | 1 | 7/19/2000 12:00:00 AM | 453054416 | DMB | 2 | 13 |
65 | 2 | 7/15/1999 12:00:00 AM | 453055889 | Dave solo | 372 | 62 |
65 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | 484 | 16 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | 152 | 15 |
67 | 1 | 7/15/2000 12:00:00 AM | 453054414 | DMB | 6 | 13 |
109 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | 152 | 15 |