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 = 453056778 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 < '7/4/2010' OR (SongInfo.ShowDate = '7/4/2010' AND SongInfo.ShowID < 453056778)) 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 |
1 | 1 | 8/8/2009 12:00:00 AM | 453056660 | DMB | DMB | 330 | 106 |
1 | 2 | 11/13/2009 12:00:00 AM | 453056750 | Dave solo | Dave Side Projects | 233 | 104 |
1 | 3 | 12/11/2009 12:00:00 AM | 453056730 | Dave & Tim | Dave Side Projects | 205 | 104 |
1 | 4 | 1/14/2004 12:00:00 AM | 453056057 | Dave & Friends | Dave Side Projects | 2363 | 77 |
1 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 5434 | 41 |
6 | 1 | 6/30/2010 12:00:00 AM | 453056775 | DMB | DMB | 4 | 110 |
6 | 2 | 5/12/2006 12:00:00 AM | 453056318 | Dave solo | Dave Side Projects | 1514 | 86 |
6 | 3 | 4/20/2008 12:00:00 AM | 453056536 | Dave & Tim | Dave Side Projects | 805 | 97 |
6 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 5560 | 41 |
12 | 1 | 2/25/2010 12:00:00 AM | 453056739 | DMB | DMB | 129 | 107 |
12 | 2 | 11/20/2002 12:00:00 AM | 453055947 | Dave solo | Dave Side Projects | 2783 | 32 |
12 | 3 | 12/12/2009 12:00:00 AM | 453056728 | Dave & Tim | Dave Side Projects | 204 | 104 |
17 | 1 | 6/30/2010 12:00:00 AM | 453056775 | DMB | DMB | 4 | 110 |
17 | 2 | 9/20/2005 12:00:00 AM | 453056242 | Dave solo | Dave Side Projects | 1748 | 84 |
17 | 3 | 5/20/2010 12:00:00 AM | 453056756 | Dave & Tim | Dave Side Projects | 45 | 109 |
17 | 4 | 12/19/2003 12:00:00 AM | 453056050 | Dave & Friends | Dave Side Projects | 2389 | 76 |
19 | 1 | 6/30/2010 12:00:00 AM | 453056775 | DMB | DMB | 4 | 110 |
19 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 5194 | 31 |
19 | 3 | 12/11/2009 12:00:00 AM | 453056730 | Dave & Tim | Dave Side Projects | 205 | 104 |
19 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 1611 | 86 |
19 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 5179 | 31 |
28 | 1 | 9/28/2008 12:00:00 AM | 453056603 | DMB | DMB | 644 | 97 |
28 | 3 | 3/29/2003 12:00:00 AM | 453055957 | Dave & Tim | Dave Side Projects | 2654 | 70 |
28 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 5179 | 31 |
37 | 1 | 8/1/2009 12:00:00 AM | 453056649 | DMB | DMB | 337 | 106 |
37 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 5194 | 31 |
37 | 3 | 3/2/2007 12:00:00 AM | 453056403 | Dave & Tim | Dave Side Projects | 1220 | 91 |
37 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 5680 | 52 |
65 | 1 | 6/30/2010 12:00:00 AM | 453056775 | DMB | DMB | 4 | 110 |
65 | 2 | 4/18/2010 12:00:00 AM | 453056823 | Dave solo | Dave Side Projects | 77 | 109 |
65 | 3 | 5/20/2010 12:00:00 AM | 453056756 | Dave & Tim | Dave Side Projects | 45 | 109 |
65 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 1611 | 86 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | Dave Side Projects | 3787 | 15 |
66 | 1 | 6/30/2010 12:00:00 AM | 453056775 | DMB | DMB | 4 | 110 |
66 | 2 | 3/19/2001 12:00:00 AM | 453055802 | Dave solo | Dave Side Projects | 3394 | 33 |
66 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | Dave Side Projects | 4119 | 16 |
66 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | Dave Side Projects | 3787 | 15 |
75 | 1 | 7/1/2010 12:00:00 AM | 453056776 | DMB | DMB | 3 | 110 |
75 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 1513 | 86 |
75 | 3 | 12/12/2009 12:00:00 AM | 453056728 | Dave & Tim | Dave Side Projects | 204 | 104 |
76 | 1 | 6/23/2010 12:00:00 AM | 453056773 | DMB | DMB | 11 | 110 |
76 | 2 | 10/19/2008 12:00:00 AM | 453056609 | Dave solo | Dave Side Projects | 623 | 97 |
76 | 3 | 8/24/2008 12:00:00 AM | 453056606 | Dave & Tim | Dave Side Projects | 679 | 97 |
76 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 1611 | 86 |
76 | 49 | 2/28/2001 12:00:00 AM | 453063291 | Trey Anastasio Band | Openers and Collaborators | 3413 | 1140 |
96 | 1 | 6/30/2010 12:00:00 AM | 453056775 | DMB | DMB | 4 | 110 |
96 | 2 | 12/16/2006 12:00:00 AM | 453056410 | Dave solo | Dave Side Projects | 1296 | 86 |
96 | 3 | 10/26/2008 12:00:00 AM | 453056610 | Dave & Tim | Dave Side Projects | 616 | 97 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 6295 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | Openers and Collaborators | 6358 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 5918 | 1133 |
96 | 45 | 4/30/2005 12:00:00 AM | 453086573 | Gov't Mule | Openers and Collaborators | 1891 | 1144 |
96 | 63 | 6/30/2004 12:00:00 AM | 453063318 | Keller Williams | Openers and Collaborators | 2195 | 1143 |
205 | 1 | 7/1/2010 12:00:00 AM | 453056776 | DMB | DMB | 3 | 110 |
205 | 2 | 11/19/2009 12:00:00 AM | 453056751 | Dave solo | Dave Side Projects | 227 | 104 |
205 | 3 | 12/10/2009 12:00:00 AM | 453056729 | Dave & Tim | Dave Side Projects | 206 | 104 |
205 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 1611 | 86 |
205 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 2856 | 32 |
205 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | Dave Side Projects | 2431 | 75 |
301 | 1 | 6/30/2010 12:00:00 AM | 453056775 | DMB | DMB | 4 | 110 |
440 | 3 | 5/20/2010 12:00:00 AM | 453056756 | Dave & Tim | Dave Side Projects | 45 | 109 |
471 | 1 | 6/18/2010 12:00:00 AM | 453056770 | DMB | DMB | 16 | 110 |
571 | 2 | 11/13/2009 12:00:00 AM | 453056750 | Dave solo | Dave Side Projects | 233 | 104 |
571 | 3 | 5/20/2010 12:00:00 AM | 453056756 | Dave & Tim | Dave Side Projects | 45 | 109 |
576 | 1 | 6/26/2010 12:00:00 AM | 453056831 | DMB | DMB | 8 | 109 |
576 | 3 | 5/20/2010 12:00:00 AM | 453056756 | Dave & Tim | Dave Side Projects | 45 | 109 |
578 | 1 | 6/30/2010 12:00:00 AM | 453056775 | DMB | DMB | 4 | 110 |
578 | 3 | 12/10/2009 12:00:00 AM | 453056729 | Dave & Tim | Dave Side Projects | 206 | 104 |
583 | 1 | 7/1/2010 12:00:00 AM | 453056776 | DMB | DMB | 3 | 110 |
628 | 2 | 1/29/2010 12:00:00 AM | 453056753 | Dave solo | Dave Side Projects | 156 | 109 |
628 | 3 | 5/20/2010 12:00:00 AM | 453056756 | Dave & Tim | Dave Side Projects | 45 | 109 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
1 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 7052 | 65 |
1 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 6505 | 57 |
1 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 6282 | 53 |
1 | 4 | 1/12/2004 12:00:00 AM | 453056053 | Dave & Friends | Dave Side Projects | 2365 | 77 |
1 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 5434 | 41 |
6 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 6882 | 65 |
6 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 6505 | 57 |
6 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 6282 | 53 |
6 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 6015 | 63 |
12 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 6882 | 65 |
12 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 6505 | 57 |
12 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 6282 | 53 |
17 | 1 | 10/22/1991 12:00:00 AM | 453055864 | DMB | DMB | 6830 | 65 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 6505 | 57 |
17 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 6282 | 53 |
17 | 4 | 12/19/2003 12:00:00 AM | 453056050 | Dave & Friends | Dave Side Projects | 2389 | 76 |
19 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 6882 | 65 |
19 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 5194 | 31 |
19 | 3 | 9/26/1994 12:00:00 AM | 453055276 | Dave & Tim | Dave Side Projects | 5760 | 52 |
19 | 4 | 10/29/2005 12:00:00 AM | 453056234 | Dave & Friends | Dave Side Projects | 1709 | 84 |
19 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 5680 | 52 |
28 | 1 | 7/8/1992 12:00:00 AM | 453055671 | DMB | DMB | 6570 | 56 |
28 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 2664 | 70 |
28 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 5680 | 52 |
37 | 1 | 10/15/1993 12:00:00 AM | 453055455 | DMB | DMB | 6106 | 51 |
37 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 5194 | 31 |
37 | 3 | 12/12/1993 12:00:00 AM | 453055494 | Dave & Tim | Dave Side Projects | 6048 | 53 |
37 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 5680 | 52 |
65 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 3667 | 13 |
65 | 2 | 3/8/1999 12:00:00 AM | 453056428 | Dave solo | Dave Side Projects | 4136 | 62 |
65 | 3 | 1/29/1999 12:00:00 AM | 453054581 | Dave & Tim | Dave Side Projects | 4174 | 16 |
65 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 2396 | 76 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | Dave Side Projects | 3787 | 15 |
66 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 3667 | 13 |
66 | 2 | 3/8/1999 12:00:00 AM | 453054607 | Dave solo | Dave Side Projects | 4136 | 62 |
66 | 3 | 2/26/1999 12:00:00 AM | 453054599 | Dave & Tim | Dave Side Projects | 4146 | 16 |
66 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | Dave Side Projects | 3787 | 15 |
75 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 3667 | 13 |
75 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 1513 | 86 |
75 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 2664 | 70 |
76 | 1 | 4/21/2001 12:00:00 AM | 2 | DMB | DMB | 3361 | 2 |
76 | 2 | 2/26/2001 12:00:00 AM | 453056339 | Dave solo | Dave Side Projects | 3415 | 1 |
76 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 2664 | 70 |
76 | 4 | 12/16/2003 12:00:00 AM | 453056048 | Dave & Friends | Dave Side Projects | 2392 | 76 |
76 | 49 | 2/28/2001 12:00:00 AM | 453063291 | Trey Anastasio Band | Openers and Collaborators | 3413 | 1140 |
96 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 6882 | 65 |
96 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 6637 | 57 |
96 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 6282 | 53 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 6295 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | Openers and Collaborators | 6358 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 5918 | 1133 |
96 | 45 | 4/30/2005 12:00:00 AM | 453086573 | Gov't Mule | Openers and Collaborators | 1891 | 1144 |
96 | 63 | 6/30/2004 12:00:00 AM | 453063318 | Keller Williams | Openers and Collaborators | 2195 | 1143 |
205 | 1 | 5/28/2002 12:00:00 AM | 453055851 | DMB | DMB | 2959 | 12 |
205 | 2 | 7/12/2002 12:00:00 AM | 453055902 | Dave solo | Dave Side Projects | 2914 | 66 |
205 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 2664 | 70 |
205 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 2396 | 76 |
205 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 2856 | 32 |
205 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | Dave Side Projects | 2431 | 75 |
301 | 1 | 5/9/2005 12:00:00 AM | 453056223 | DMB | DMB | 1882 | 84 |
440 | 1 | 8/1/2007 12:00:00 AM | 453056468 | DMB | DMB | 1068 | 96 |
440 | 3 | 2/23/2007 12:00:00 AM | 453056398 | Dave & Tim | Dave Side Projects | 1227 | 91 |
471 | 1 | 5/28/2010 12:00:00 AM | 453056760 | DMB | DMB | 37 | 110 |
571 | 1 | 6/6/2009 12:00:00 AM | 453056644 | DMB | DMB | 393 | 106 |
571 | 2 | 11/13/2009 12:00:00 AM | 453056750 | Dave solo | Dave Side Projects | 233 | 104 |
571 | 3 | 6/25/2009 12:00:00 AM | 453056713 | Dave & Tim | Dave Side Projects | 374 | 104 |
576 | 1 | 4/14/2009 12:00:00 AM | 453056612 | DMB | DMB | 446 | 103 |
576 | 3 | 12/10/2009 12:00:00 AM | 453056729 | Dave & Tim | Dave Side Projects | 206 | 104 |
578 | 1 | 5/27/2009 12:00:00 AM | 453056640 | DMB | DMB | 403 | 106 |
578 | 3 | 12/10/2009 12:00:00 AM | 453056729 | Dave & Tim | Dave Side Projects | 206 | 104 |
583 | 1 | 4/14/2009 12:00:00 AM | 453056612 | DMB | DMB | 446 | 103 |
628 | 1 | 5/29/2010 12:00:00 AM | 453056761 | DMB | DMB | 36 | 110 |
628 | 2 | 1/29/2010 12:00:00 AM | 453056753 | Dave solo | Dave Side Projects | 156 | 109 |
628 | 3 | 5/20/2010 12:00:00 AM | 453056756 | Dave & Tim | Dave Side Projects | 45 | 109 |