SELECT SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate, SongInfo.ShowID, ShowArtists.ShortName, ArtistCategories.CategoryName, DATEDIFF (D, SongInfo.ShowDate, ThisShow.ShowDate) NumDays, ShowInfo.TourID FROM SongInfo INNER JOIN SongInfo ThisShow ON ThisShow.SongID = SongInfo.SongID AND ThisShow.ShowID = 453056556 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID INNER JOIN ArtistCategories ON ShowArtists.ArtistCategoryID = ArtistCategories.CategoryID WHERE (SongInfo.ShowDate < '6/28/2008' OR (SongInfo.ShowDate = '6/28/2008' AND SongInfo.ShowID < 453056556)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
17 | 1 | 6/27/2008 12:00:00 AM | 453056555 | DMB | DMB | 1 | 98 |
17 | 2 | 9/20/2005 12:00:00 AM | 453056242 | Dave solo | Dave Side Projects | 1012 | 84 |
17 | 3 | 5/20/2008 12:00:00 AM | 453056597 | Dave & Tim | Dave Side Projects | 39 | 97 |
17 | 4 | 12/19/2003 12:00:00 AM | 453056050 | Dave & Friends | Dave Side Projects | 1653 | 76 |
19 | 1 | 6/27/2008 12:00:00 AM | 453056555 | DMB | DMB | 1 | 98 |
19 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 4458 | 31 |
19 | 3 | 4/21/2007 12:00:00 AM | 453056465 | Dave & Tim | Dave Side Projects | 434 | 93 |
19 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 875 | 86 |
19 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 4443 | 31 |
21 | 1 | 6/27/2008 12:00:00 AM | 453056555 | DMB | DMB | 1 | 98 |
21 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 777 | 86 |
21 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 1881 | 75 |
47 | 1 | 6/27/2008 12:00:00 AM | 453056555 | DMB | DMB | 1 | 98 |
47 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 777 | 86 |
47 | 3 | 10/28/2005 12:00:00 AM | 453056235 | Dave & Tim | Dave Side Projects | 974 | 84 |
47 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 875 | 86 |
47 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 4443 | 31 |
49 | 1 | 6/25/2008 12:00:00 AM | 453056554 | DMB | DMB | 3 | 98 |
49 | 2 | 9/18/2005 12:00:00 AM | 453056233 | Dave solo | Dave Side Projects | 1014 | 84 |
49 | 3 | 4/19/2008 12:00:00 AM | 453056535 | Dave & Tim | Dave Side Projects | 70 | 97 |
49 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 1659 | 76 |
56 | 1 | 6/24/2008 12:00:00 AM | 453056553 | DMB | DMB | 4 | 98 |
56 | 3 | 1/23/1999 12:00:00 AM | 453054576 | Dave & Tim | Dave Side Projects | 3444 | 16 |
57 | 1 | 6/24/2008 12:00:00 AM | 453056553 | DMB | DMB | 4 | 98 |
57 | 3 | 4/21/2007 12:00:00 AM | 453056465 | Dave & Tim | Dave Side Projects | 434 | 93 |
57 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 875 | 86 |
61 | 1 | 6/24/2008 12:00:00 AM | 453056553 | DMB | DMB | 4 | 98 |
61 | 3 | 4/6/2008 12:00:00 AM | 453056593 | Dave & Tim | Dave Side Projects | 83 | 97 |
76 | 1 | 6/27/2008 12:00:00 AM | 453056555 | DMB | DMB | 1 | 98 |
76 | 2 | 9/30/2006 12:00:00 AM | 453056334 | Dave solo | Dave Side Projects | 637 | 86 |
76 | 3 | 4/11/2008 12:00:00 AM | 453056537 | Dave & Tim | Dave Side Projects | 78 | 97 |
76 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 875 | 86 |
76 | 49 | 2/28/2001 12:00:00 AM | 453063291 | Trey Anastasio Band | Openers and Collaborators | 2677 | 1140 |
80 | 1 | 7/13/2004 12:00:00 AM | 453056092 | DMB | DMB | 1446 | 80 |
80 | 2 | 10/24/2002 12:00:00 AM | 453055916 | Dave solo | Dave Side Projects | 2074 | 32 |
92 | 1 | 6/27/2008 12:00:00 AM | 453056555 | DMB | DMB | 1 | 98 |
233 | 2 | 12/16/2006 12:00:00 AM | 453056410 | Dave solo | Dave Side Projects | 560 | 86 |
233 | 3 | 5/20/2008 12:00:00 AM | 453056597 | Dave & Tim | Dave Side Projects | 39 | 97 |
233 | 4 | 2/5/2006 12:00:00 AM | 453056321 | Dave & Friends | Dave Side Projects | 874 | 86 |
257 | 1 | 6/25/2008 12:00:00 AM | 453056554 | DMB | DMB | 3 | 98 |
257 | 4 | 10/29/2005 12:00:00 AM | 453056234 | Dave & Friends | Dave Side Projects | 973 | 84 |
257 | 68 | 9/20/2005 12:00:00 AM | 453063331 | Trey Anastasio & 70 Volt Parade | Openers and Collaborators | 1012 | 1144 |
289 | 1 | 6/27/2008 12:00:00 AM | 453056555 | DMB | DMB | 1 | 98 |
289 | 2 | 9/30/2006 12:00:00 AM | 453056334 | Dave solo | Dave Side Projects | 637 | 86 |
289 | 3 | 4/20/2008 12:00:00 AM | 453056536 | Dave & Tim | Dave Side Projects | 69 | 97 |
289 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 875 | 86 |
295 | 1 | 6/25/2008 12:00:00 AM | 453056554 | DMB | DMB | 3 | 98 |
295 | 71 | 4/20/2006 12:00:00 AM | 453063333 | Robert Randolph & The Family Band | Openers and Collaborators | 800 | 1145 |
299 | 1 | 6/27/2008 12:00:00 AM | 453056555 | DMB | DMB | 1 | 98 |
299 | 3 | 4/22/2007 12:00:00 AM | 453056467 | Dave & Tim | Dave Side Projects | 433 | 93 |
301 | 1 | 6/27/2008 12:00:00 AM | 453056555 | DMB | DMB | 1 | 98 |
304 | 2 | 9/30/2006 12:00:00 AM | 453056334 | Dave solo | Dave Side Projects | 637 | 86 |
304 | 3 | 4/19/2008 12:00:00 AM | 453056535 | Dave & Tim | Dave Side Projects | 70 | 97 |
343 | 1 | 6/27/2008 12:00:00 AM | 453056555 | DMB | DMB | 1 | 98 |
343 | 2 | 5/12/2006 12:00:00 AM | 453056318 | Dave solo | Dave Side Projects | 778 | 86 |
343 | 3 | 4/19/2008 12:00:00 AM | 453056535 | Dave & Tim | Dave Side Projects | 70 | 97 |
343 | 4 | 2/5/2006 12:00:00 AM | 453056322 | Dave & Friends | Dave Side Projects | 874 | 86 |
370 | 1 | 6/25/2008 12:00:00 AM | 453056554 | DMB | DMB | 3 | 98 |
440 | 3 | 4/20/2008 12:00:00 AM | 453056536 | Dave & Tim | Dave Side Projects | 69 | 97 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
17 | 1 | 10/22/1991 12:00:00 AM | 453055864 | DMB | DMB | 6094 | 65 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 5769 | 57 |
17 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 5546 | 53 |
17 | 4 | 12/19/2003 12:00:00 AM | 453056050 | Dave & Friends | Dave Side Projects | 1653 | 76 |
19 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 6146 | 65 |
19 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 4458 | 31 |
19 | 3 | 9/26/1994 12:00:00 AM | 453055276 | Dave & Tim | Dave Side Projects | 5024 | 52 |
19 | 4 | 10/29/2005 12:00:00 AM | 453056234 | Dave & Friends | Dave Side Projects | 973 | 84 |
19 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 4944 | 52 |
21 | 1 | 2/13/1992 12:00:00 AM | 453055738 | DMB | DMB | 5980 | 56 |
21 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 5769 | 57 |
21 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 5546 | 53 |
47 | 1 | 10/4/1995 12:00:00 AM | 453055261 | DMB | DMB | 4651 | 41 |
47 | 2 | 3/8/1999 12:00:00 AM | 453054607 | Dave solo | Dave Side Projects | 3400 | 62 |
47 | 3 | 12/16/1996 12:00:00 AM | 453055128 | Dave & Tim | Dave Side Projects | 4212 | 31 |
47 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 1659 | 76 |
47 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 4443 | 31 |
49 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 3724 | 23 |
49 | 2 | 7/1/1998 12:00:00 AM | 453056508 | Dave solo | Dave Side Projects | 3650 | 23 |
49 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 3448 | 16 |
49 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 1659 | 76 |
56 | 1 | 11/29/1994 12:00:00 AM | 453055320 | DMB | DMB | 4960 | 45 |
56 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 3448 | 16 |
57 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 3724 | 23 |
57 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 3448 | 16 |
57 | 4 | 10/29/2005 12:00:00 AM | 453056234 | Dave & Friends | Dave Side Projects | 973 | 84 |
61 | 1 | 5/25/1998 12:00:00 AM | 453054700 | DMB | DMB | 3687 | 19 |
61 | 3 | 9/9/2007 12:00:00 AM | 453056515 | Dave & Tim | Dave Side Projects | 293 | 93 |
76 | 1 | 4/21/2001 12:00:00 AM | 2 | DMB | DMB | 2625 | 2 |
76 | 2 | 2/26/2001 12:00:00 AM | 453056339 | Dave solo | Dave Side Projects | 2679 | 1 |
76 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 1928 | 70 |
76 | 4 | 12/16/2003 12:00:00 AM | 453056048 | Dave & Friends | Dave Side Projects | 1656 | 76 |
76 | 49 | 2/28/2001 12:00:00 AM | 453063291 | Trey Anastasio Band | Openers and Collaborators | 2677 | 1140 |
80 | 1 | 2/24/2001 12:00:00 AM | 453055934 | DMB | DMB | 2681 | 1 |
80 | 2 | 2/23/2001 12:00:00 AM | 453055792 | Dave solo | Dave Side Projects | 2682 | 33 |
92 | 1 | 10/3/1996 12:00:00 AM | 453055078 | DMB | DMB | 4286 | 29 |
233 | 1 | 5/27/2007 12:00:00 AM | 453056424 | DMB | DMB | 398 | 92 |
233 | 2 | 8/6/2003 12:00:00 AM | 453056038 | Dave solo | Dave Side Projects | 1788 | 75 |
233 | 3 | 10/28/2005 12:00:00 AM | 453056235 | Dave & Tim | Dave Side Projects | 974 | 84 |
233 | 4 | 11/8/2003 12:00:00 AM | 453056058 | Dave & Friends | Dave Side Projects | 1694 | 75 |
257 | 1 | 5/30/2008 12:00:00 AM | 453056540 | DMB | DMB | 29 | 98 |
257 | 4 | 12/19/2003 12:00:00 AM | 453056050 | Dave & Friends | Dave Side Projects | 1653 | 76 |
257 | 68 | 4/30/2005 12:00:00 AM | 453063327 | Trey Anastasio & 70 Volt Parade | Openers and Collaborators | 1155 | 1144 |
289 | 1 | 6/2/2005 12:00:00 AM | 453056174 | DMB | DMB | 1122 | 83 |
289 | 2 | 2/28/2006 12:00:00 AM | 453056317 | Dave solo | Dave Side Projects | 851 | 86 |
289 | 3 | 10/28/2005 12:00:00 AM | 453056235 | Dave & Tim | Dave Side Projects | 974 | 84 |
289 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 875 | 86 |
295 | 1 | 4/30/2005 12:00:00 AM | 453056213 | DMB | DMB | 1155 | 84 |
295 | 71 | 4/20/2006 12:00:00 AM | 453063333 | Robert Randolph & The Family Band | Openers and Collaborators | 800 | 1145 |
299 | 1 | 6/4/2005 12:00:00 AM | 453056175 | DMB | DMB | 1120 | 83 |
299 | 3 | 4/22/2007 12:00:00 AM | 453056467 | Dave & Tim | Dave Side Projects | 433 | 93 |
301 | 1 | 5/9/2005 12:00:00 AM | 453056223 | DMB | DMB | 1146 | 84 |
304 | 1 | 5/30/2006 12:00:00 AM | 453056266 | DMB | DMB | 760 | 87 |
304 | 2 | 5/11/2006 12:00:00 AM | 453056332 | Dave solo | Dave Side Projects | 779 | 86 |
304 | 3 | 10/27/2006 12:00:00 AM | 453056382 | Dave & Tim | Dave Side Projects | 610 | 86 |
343 | 1 | 8/18/2007 12:00:00 AM | 453056479 | DMB | DMB | 315 | 96 |
343 | 2 | 5/12/2006 12:00:00 AM | 453056318 | Dave solo | Dave Side Projects | 778 | 86 |
343 | 3 | 4/22/2007 12:00:00 AM | 453056467 | Dave & Tim | Dave Side Projects | 433 | 93 |
343 | 4 | 2/5/2006 12:00:00 AM | 453056321 | Dave & Friends | Dave Side Projects | 874 | 86 |
370 | 1 | 6/2/2006 12:00:00 AM | 453056268 | DMB | DMB | 757 | 87 |
440 | 1 | 8/1/2007 12:00:00 AM | 453056468 | DMB | DMB | 332 | 96 |
440 | 3 | 2/23/2007 12:00:00 AM | 453056398 | Dave & Tim | Dave Side Projects | 491 | 91 |