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 = 453056700 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '9/10/2009' OR (SongInfo.ShowDate = '9/10/2009' AND SongInfo.ShowID < 453056700)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
9 | 1 | 9/6/2009 12:00:00 AM | 453056669 | DMB | 4 | 106 |
9 | 2 | 10/27/1998 12:00:00 AM | 453056430 | Dave solo | 3971 | 34 |
9 | 3 | 10/27/2006 12:00:00 AM | 453056382 | Dave & Tim | 1049 | 86 |
9 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | 1762 | 79 |
11 | 1 | 9/4/2009 12:00:00 AM | 453056667 | DMB | 6 | 106 |
11 | 2 | 5/12/2006 12:00:00 AM | 453056318 | Dave solo | 1217 | 86 |
11 | 3 | 10/26/2008 12:00:00 AM | 453056610 | Dave & Tim | 319 | 97 |
11 | 4 | 12/17/2003 12:00:00 AM | 453056049 | Dave & Friends | 2094 | 76 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | 5718 | 63 |
17 | 1 | 9/5/2009 12:00:00 AM | 453056668 | DMB | 5 | 106 |
17 | 2 | 9/20/2005 12:00:00 AM | 453056242 | Dave solo | 1451 | 84 |
17 | 3 | 10/26/2008 12:00:00 AM | 453056610 | Dave & Tim | 319 | 97 |
17 | 4 | 12/19/2003 12:00:00 AM | 453056050 | Dave & Friends | 2092 | 76 |
22 | 1 | 9/5/2009 12:00:00 AM | 453056668 | DMB | 5 | 106 |
22 | 2 | 5/15/2006 12:00:00 AM | 453056320 | Dave solo | 1214 | 86 |
22 | 3 | 5/20/2008 12:00:00 AM | 453056597 | Dave & Tim | 478 | 97 |
22 | 4 | 1/16/2004 12:00:00 AM | 453056056 | Dave & Friends | 2064 | 77 |
22 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | 5998 | 53 |
22 | 15 | 10/29/1994 12:00:00 AM | 453089864 | Dave & Boyd | 5430 | 63 |
33 | 1 | 7/29/2009 12:00:00 AM | 453056647 | DMB | 43 | 106 |
33 | 3 | 2/21/1997 12:00:00 AM | 453054953 | Dave & Tim | 4584 | 24 |
33 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | 5263 | 41 |
58 | 1 | 9/5/2009 12:00:00 AM | 453056668 | DMB | 5 | 106 |
58 | 2 | 8/6/2003 12:00:00 AM | 453056038 | Dave solo | 2227 | 75 |
58 | 3 | 10/26/2008 12:00:00 AM | 453056610 | Dave & Tim | 319 | 97 |
58 | 4 | 1/16/2004 12:00:00 AM | 453056056 | Dave & Friends | 2064 | 77 |
76 | 1 | 9/5/2009 12:00:00 AM | 453056668 | DMB | 5 | 106 |
76 | 2 | 10/19/2008 12:00:00 AM | 453056609 | Dave solo | 326 | 97 |
76 | 3 | 8/24/2008 12:00:00 AM | 453056606 | Dave & Tim | 382 | 97 |
76 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | 1314 | 86 |
76 | 49 | 2/28/2001 12:00:00 AM | 453063291 | Trey Anastasio Band | 3116 | 1140 |
127 | 1 | 9/6/2008 12:00:00 AM | 453056579 | DMB | 369 | 98 |
127 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | 6208 | 57 |
127 | 3 | 4/22/2007 12:00:00 AM | 453056467 | Dave & Tim | 872 | 93 |
127 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | 2098 | 76 |
127 | 7 | 1/9/2008 12:00:00 AM | 453056523 | Yukon Kornelius | 610 | 97 |
127 | 12 | 1/12/1993 12:00:00 AM | 453055495 | C-ville Allstars | 6085 | 53 |
127 | 20 | 5/6/2001 12:00:00 AM | 453056944 | Jazzfest Superjam | 3049 | 1 |
127 | 26 | 1/16/1994 12:00:00 AM | 453063247 | The Samples | 5716 | 1133 |
127 | 31 | 10/15/1994 12:00:00 AM | 453063256 | Phish | 5444 | 1133 |
127 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | 5137 | 41 |
205 | 1 | 9/4/2009 12:00:00 AM | 453056667 | DMB | 6 | 106 |
205 | 2 | 12/21/2007 12:00:00 AM | 453056524 | Dave solo | 629 | 93 |
205 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | 66 | 104 |
205 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | 1314 | 86 |
205 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | 2559 | 32 |
205 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | 2134 | 75 |
299 | 1 | 7/19/2009 12:00:00 AM | 453056636 | DMB | 53 | 106 |
299 | 3 | 8/24/2008 12:00:00 AM | 453056606 | Dave & Tim | 382 | 97 |
304 | 1 | 8/14/2009 12:00:00 AM | 453056662 | DMB | 27 | 106 |
304 | 2 | 9/30/2006 12:00:00 AM | 453056334 | Dave solo | 1076 | 86 |
304 | 3 | 10/26/2008 12:00:00 AM | 453056610 | Dave & Tim | 319 | 97 |
574 | 1 | 9/9/2009 12:00:00 AM | 453056699 | DMB | 1 | 106 |
575 | 3 | 6/25/2009 12:00:00 AM | 453056713 | Dave & Tim | 77 | 104 |
576 | 1 | 9/6/2009 12:00:00 AM | 453056669 | DMB | 4 | 106 |
579 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | 66 | 104 |
580 | 1 | 9/9/2009 12:00:00 AM | 453056699 | DMB | 1 | 106 |
586 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | 66 | 104 |