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 = 453056690 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '10/3/2009' OR (SongInfo.ShowDate = '10/3/2009' AND SongInfo.ShowID < 453056690)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
13 | 1 | 9/13/2009 12:00:00 AM | 453056671 | DMB | 20 | 106 |
13 | 2 | 6/11/1999 12:00:00 AM | 453055897 | Dave solo | 3767 | 62 |
13 | 3 | 10/26/2008 12:00:00 AM | 453056610 | Dave & Tim | 342 | 97 |
13 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | 1337 | 86 |
13 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | 4905 | 31 |
17 | 1 | 9/26/2009 12:00:00 AM | 453056676 | DMB | 7 | 106 |
17 | 2 | 9/20/2005 12:00:00 AM | 453056242 | Dave solo | 1474 | 84 |
17 | 3 | 10/26/2008 12:00:00 AM | 453056610 | Dave & Tim | 342 | 97 |
17 | 4 | 12/19/2003 12:00:00 AM | 453056050 | Dave & Friends | 2115 | 76 |
19 | 1 | 10/2/2009 12:00:00 AM | 453056679 | DMB | 1 | 106 |
19 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | 4920 | 31 |
19 | 3 | 4/21/2007 12:00:00 AM | 453056465 | Dave & Tim | 896 | 93 |
19 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | 1337 | 86 |
19 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | 4905 | 31 |
21 | 1 | 9/30/2009 12:00:00 AM | 453056678 | DMB | 3 | 106 |
21 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | 1239 | 86 |
21 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | 2343 | 75 |
47 | 1 | 4/18/2009 12:00:00 AM | 453056615 | DMB | 168 | 103 |
47 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | 1239 | 86 |
47 | 3 | 10/28/2005 12:00:00 AM | 453056235 | Dave & Tim | 1436 | 84 |
47 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | 1337 | 86 |
47 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | 4905 | 31 |
49 | 1 | 9/29/2009 12:00:00 AM | 453056677 | DMB | 4 | 106 |
49 | 2 | 10/19/2008 12:00:00 AM | 453056609 | Dave solo | 349 | 97 |
49 | 3 | 10/26/2008 12:00:00 AM | 453056610 | Dave & Tim | 342 | 97 |
49 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | 2121 | 76 |
92 | 1 | 9/30/2009 12:00:00 AM | 453056678 | DMB | 3 | 106 |
233 | 2 | 10/19/2008 12:00:00 AM | 453056609 | Dave solo | 349 | 97 |
233 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | 89 | 104 |
233 | 4 | 2/5/2006 12:00:00 AM | 453056321 | Dave & Friends | 1336 | 86 |
301 | 1 | 10/2/2009 12:00:00 AM | 453056679 | DMB | 1 | 106 |
440 | 3 | 10/26/2008 12:00:00 AM | 453056610 | Dave & Tim | 342 | 97 |
557 | 1 | 9/29/2009 12:00:00 AM | 453056677 | DMB | 4 | 106 |
579 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | 89 | 104 |
583 | 1 | 10/2/2009 12:00:00 AM | 453056679 | DMB | 1 | 106 |