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 = 453089805 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 < '8/27/2021' OR (SongInfo.ShowDate = '8/27/2021' AND SongInfo.ShowID < 453089805)) 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/30/2019 12:00:00 AM | 453086608 | DMB | DMB | 728 | 7160 |
1 | 2 | 9/11/2019 12:00:00 AM | 453089611 | Dave solo | Dave Side Projects | 716 | 6158 |
1 | 3 | 2/14/2020 12:00:00 AM | 453089607 | Dave & Tim | Dave Side Projects | 560 | 8162 |
1 | 4 | 1/14/2004 12:00:00 AM | 453056057 | Dave & Friends | Dave Side Projects | 6435 | 77 |
1 | 13 | 11/19/2020 12:00:00 AM | 453089784 | Dave & Carter | DMB | 281 | 8166 |
1 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 9506 | 41 |
4 | 1 | 8/13/2021 12:00:00 AM | 453089798 | DMB | DMB | 14 | 8164 |
4 | 2 | 7/3/2020 12:00:00 AM | 453089747 | Dave solo | Dave Side Projects | 420 | 8166 |
4 | 3 | 2/15/2020 12:00:00 AM | 453089608 | Dave & Tim | Dave Side Projects | 559 | 8162 |
5 | 1 | 8/24/2021 12:00:00 AM | 453089803 | DMB | DMB | 3 | 8164 |
5 | 2 | 9/19/2018 12:00:00 AM | 453083559 | Dave solo | Dave Side Projects | 1073 | 5156 |
5 | 3 | 2/16/2020 12:00:00 AM | 453089609 | Dave & Tim | Dave Side Projects | 558 | 8162 |
5 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 5683 | 86 |
11 | 1 | 8/24/2021 12:00:00 AM | 453089803 | DMB | DMB | 3 | 8164 |
11 | 2 | 4/22/2021 12:00:00 AM | 453089826 | Dave solo | Dave Side Projects | 127 | 8165 |
11 | 3 | 2/14/2020 12:00:00 AM | 453089607 | Dave & Tim | Dave Side Projects | 560 | 8162 |
11 | 4 | 12/17/2003 12:00:00 AM | 453056049 | Dave & Friends | Dave Side Projects | 6463 | 76 |
11 | 13 | 11/19/2020 12:00:00 AM | 453089784 | Dave & Carter | DMB | 281 | 8166 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 10087 | 63 |
17 | 1 | 8/25/2021 12:00:00 AM | 453089804 | DMB | DMB | 2 | 8164 |
17 | 2 | 8/19/2021 12:00:00 AM | 453089841 | Dave solo | Dave Side Projects | 8 | 8165 |
17 | 3 | 2/15/2020 12:00:00 AM | 453089608 | Dave & Tim | Dave Side Projects | 559 | 8162 |
17 | 4 | 12/19/2003 12:00:00 AM | 453056050 | Dave & Friends | Dave Side Projects | 6461 | 76 |
17 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 1748 | 1154 |
17 | 3058 | 11/1/2016 12:00:00 AM | 453068422 | Joshua Bell | Openers and Collaborators | 1760 | 1154 |
17 | 9090 | 8/13/2021 12:00:00 AM | 453089840 | The Cadets | Openers and Collaborators | 14 | 8168 |
28 | 1 | 8/21/2021 12:00:00 AM | 453089802 | DMB | DMB | 6 | 8164 |
28 | 3 | 3/29/2003 12:00:00 AM | 453055957 | Dave & Tim | Dave Side Projects | 6726 | 70 |
28 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 9251 | 31 |
42 | 1 | 8/25/2021 12:00:00 AM | 453089804 | DMB | DMB | 2 | 8164 |
42 | 2 | 7/3/2020 12:00:00 AM | 453089747 | Dave solo | Dave Side Projects | 420 | 8166 |
42 | 3 | 1/14/2018 12:00:00 AM | 453074457 | Dave & Tim | Dave Side Projects | 1321 | 5156 |
44 | 1 | 8/24/2021 12:00:00 AM | 453089803 | DMB | DMB | 3 | 8164 |
44 | 2 | 5/15/2020 12:00:00 AM | 453089733 | Dave solo | Dave Side Projects | 469 | 8166 |
44 | 3 | 6/10/2017 12:00:00 AM | 453071419 | Dave & Tim | Dave Side Projects | 1539 | 5154 |
55 | 1 | 8/25/2021 12:00:00 AM | 453089804 | DMB | DMB | 2 | 8164 |
55 | 2 | 8/19/2021 12:00:00 AM | 453089841 | Dave solo | Dave Side Projects | 8 | 8165 |
55 | 3 | 2/15/2020 12:00:00 AM | 453089608 | Dave & Tim | Dave Side Projects | 559 | 8162 |
55 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 6131 | 79 |
55 | 1024 | 9/4/2014 12:00:00 AM | 453057206 | Dave, Tim & Rashawn | DMB | 2549 | 122 |
55 | 7057 | 12/10/2017 12:00:00 AM | 453078475 | Stevie Wonder | Openers and Collaborators | 1356 | 5155 |
56 | 1 | 8/18/2021 12:00:00 AM | 453089800 | DMB | DMB | 9 | 8164 |
56 | 3 | 2/15/2020 12:00:00 AM | 453089608 | Dave & Tim | Dave Side Projects | 559 | 8162 |
57 | 1 | 8/18/2021 12:00:00 AM | 453089800 | DMB | DMB | 9 | 8164 |
57 | 3 | 9/24/2019 12:00:00 AM | 453089617 | Dave & Tim | Dave Side Projects | 703 | 6158 |
57 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 5683 | 86 |
65 | 1 | 8/6/2021 12:00:00 AM | 453089795 | DMB | DMB | 21 | 8164 |
65 | 2 | 8/19/2021 12:00:00 AM | 453089841 | Dave solo | Dave Side Projects | 8 | 8165 |
65 | 3 | 2/14/2020 12:00:00 AM | 453089607 | Dave & Tim | Dave Side Projects | 560 | 8162 |
65 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 5683 | 86 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | Dave Side Projects | 7859 | 15 |
74 | 1 | 8/6/2021 12:00:00 AM | 453089795 | DMB | DMB | 21 | 8164 |
74 | 3 | 3/31/2003 12:00:00 AM | 453055958 | Dave & Tim | Dave Side Projects | 6724 | 70 |
233 | 1 | 8/25/2021 12:00:00 AM | 453089804 | DMB | DMB | 2 | 8164 |
233 | 2 | 8/19/2021 12:00:00 AM | 453089841 | Dave solo | Dave Side Projects | 8 | 8165 |
233 | 3 | 2/14/2020 12:00:00 AM | 453089607 | Dave & Tim | Dave Side Projects | 560 | 8162 |
233 | 4 | 2/5/2006 12:00:00 AM | 453056321 | Dave & Friends | Dave Side Projects | 5682 | 86 |
295 | 1 | 8/24/2021 12:00:00 AM | 453089803 | DMB | DMB | 3 | 8164 |
295 | 71 | 4/20/2006 12:00:00 AM | 453063333 | Robert Randolph & The Family Band | Openers and Collaborators | 5608 | 1145 |
376 | 1 | 8/24/2021 12:00:00 AM | 453089803 | DMB | DMB | 3 | 8164 |
376 | 3 | 1/15/2014 12:00:00 AM | 453057148 | Dave & Tim | Dave Side Projects | 2781 | 122 |
549 | 1 | 8/25/2021 12:00:00 AM | 453089804 | DMB | DMB | 2 | 8164 |
549 | 2 | 3/12/2020 12:00:00 AM | 453089631 | Dave solo | Dave Side Projects | 533 | 8162 |
549 | 8 | 8/26/2017 12:00:00 AM | 453073455 | Secret Stash | Stefan Side Projects | 1462 | 3154 |
571 | 1 | 8/20/2021 12:00:00 AM | 453089801 | DMB | DMB | 7 | 8164 |
571 | 2 | 7/28/2011 12:00:00 AM | 453056947 | Dave solo | Dave Side Projects | 3683 | 114 |
571 | 3 | 2/15/2020 12:00:00 AM | 453089608 | Dave & Tim | Dave Side Projects | 559 | 8162 |
583 | 1 | 8/21/2021 12:00:00 AM | 453089802 | DMB | DMB | 6 | 8164 |
583 | 3 | 2/16/2020 12:00:00 AM | 453089609 | Dave & Tim | Dave Side Projects | 558 | 8162 |
767 | 1 | 8/14/2021 12:00:00 AM | 453089799 | DMB | DMB | 13 | 8164 |
4873 | 2 | 7/3/2020 12:00:00 AM | 453089747 | Dave solo | Dave Side Projects | 420 | 8166 |
4873 | 3 | 2/14/2020 12:00:00 AM | 453089607 | Dave & Tim | Dave Side Projects | 560 | 8162 |
4873 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 1748 | 1154 |
4873 | 3058 | 11/1/2016 12:00:00 AM | 453068422 | Joshua Bell | Openers and Collaborators | 1760 | 1154 |
22033 | 1 | 8/21/2021 12:00:00 AM | 453089802 | DMB | DMB | 6 | 8164 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
1 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 11124 | 65 |
1 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 10577 | 57 |
1 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 10354 | 53 |
1 | 4 | 1/12/2004 12:00:00 AM | 453056053 | Dave & Friends | Dave Side Projects | 6437 | 77 |
1 | 13 | 11/19/2020 12:00:00 AM | 453089784 | Dave & Carter | DMB | 281 | 8166 |
1 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 9506 | 41 |
4 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 11124 | 65 |
4 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 10709 | 57 |
4 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 10354 | 53 |
5 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 11124 | 65 |
5 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 10709 | 57 |
5 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 10354 | 53 |
5 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 5683 | 86 |
11 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 10954 | 65 |
11 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 10577 | 57 |
11 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 10354 | 53 |
11 | 4 | 12/15/2003 12:00:00 AM | 453056047 | Dave & Friends | Dave Side Projects | 6465 | 76 |
11 | 13 | 11/19/2020 12:00:00 AM | 453089784 | Dave & Carter | DMB | 281 | 8166 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 10087 | 63 |
17 | 1 | 10/22/1991 12:00:00 AM | 453055864 | DMB | DMB | 10902 | 65 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 10577 | 57 |
17 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 10354 | 53 |
17 | 4 | 12/19/2003 12:00:00 AM | 453056050 | Dave & Friends | Dave Side Projects | 6461 | 76 |
17 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 1748 | 1154 |
17 | 3058 | 11/1/2016 12:00:00 AM | 453068422 | Joshua Bell | Openers and Collaborators | 1760 | 1154 |
17 | 9090 | 8/13/2021 12:00:00 AM | 453089840 | The Cadets | Openers and Collaborators | 14 | 8168 |
28 | 1 | 7/8/1992 12:00:00 AM | 453055671 | DMB | DMB | 10642 | 56 |
28 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 6736 | 70 |
28 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 9752 | 52 |
42 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 8532 | 23 |
42 | 2 | 7/3/2020 12:00:00 AM | 453089747 | Dave solo | Dave Side Projects | 420 | 8166 |
42 | 3 | 6/3/2017 12:00:00 AM | 453071415 | Dave & Tim | Dave Side Projects | 1546 | 5154 |
44 | 1 | 12/16/1994 12:00:00 AM | 453056378 | DMB | DMB | 9751 | 45 |
44 | 2 | 5/15/2020 12:00:00 AM | 453089733 | Dave solo | Dave Side Projects | 469 | 8166 |
44 | 3 | 2/8/1996 12:00:00 AM | 453054997 | Dave & Tim | Dave Side Projects | 9332 | 27 |
55 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 8532 | 23 |
55 | 2 | 9/29/2001 12:00:00 AM | 55 | Dave solo | Dave Side Projects | 7272 | 1 |
55 | 3 | 1/20/1999 12:00:00 AM | 453054574 | Dave & Tim | Dave Side Projects | 8255 | 16 |
55 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 6468 | 76 |
55 | 1024 | 9/4/2014 12:00:00 AM | 453057206 | Dave, Tim & Rashawn | DMB | 2549 | 122 |
55 | 7057 | 12/10/2017 12:00:00 AM | 453078475 | Stevie Wonder | Openers and Collaborators | 1356 | 5155 |
56 | 1 | 11/29/1994 12:00:00 AM | 453055320 | DMB | DMB | 9768 | 45 |
56 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 8256 | 16 |
57 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 8532 | 23 |
57 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 8256 | 16 |
57 | 4 | 10/29/2005 12:00:00 AM | 453056234 | Dave & Friends | Dave Side Projects | 5781 | 84 |
65 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 7739 | 13 |
65 | 2 | 3/8/1999 12:00:00 AM | 453056428 | Dave solo | Dave Side Projects | 8208 | 62 |
65 | 3 | 1/29/1999 12:00:00 AM | 453054581 | Dave & Tim | Dave Side Projects | 8246 | 16 |
65 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 6468 | 76 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | Dave Side Projects | 7859 | 15 |
74 | 1 | 5/14/2001 12:00:00 AM | 13 | DMB | DMB | 7410 | 2 |
74 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 6736 | 70 |
233 | 1 | 5/27/2007 12:00:00 AM | 453056424 | DMB | DMB | 5206 | 92 |
233 | 2 | 8/6/2003 12:00:00 AM | 453056038 | Dave solo | Dave Side Projects | 6596 | 75 |
233 | 3 | 10/28/2005 12:00:00 AM | 453056235 | Dave & Tim | Dave Side Projects | 5782 | 84 |
233 | 4 | 11/8/2003 12:00:00 AM | 453056058 | Dave & Friends | Dave Side Projects | 6502 | 75 |
295 | 1 | 4/30/2005 12:00:00 AM | 453056213 | DMB | DMB | 5963 | 84 |
295 | 71 | 4/20/2006 12:00:00 AM | 453063333 | Robert Randolph & The Family Band | Openers and Collaborators | 5608 | 1145 |
376 | 1 | 6/23/2006 12:00:00 AM | 453056280 | DMB | DMB | 5544 | 87 |
376 | 3 | 2/24/2007 12:00:00 AM | 453056399 | Dave & Tim | Dave Side Projects | 5298 | 91 |
549 | 1 | 6/28/2008 12:00:00 AM | 453056556 | DMB | DMB | 4808 | 98 |
549 | 2 | 8/3/2019 12:00:00 AM | 453089606 | Dave solo | Dave Side Projects | 755 | 6158 |
549 | 8 | 8/26/2017 12:00:00 AM | 453073455 | Secret Stash | Stefan Side Projects | 1462 | 3154 |
571 | 1 | 6/6/2009 12:00:00 AM | 453056644 | DMB | DMB | 4465 | 106 |
571 | 2 | 11/13/2009 12:00:00 AM | 453056750 | Dave solo | Dave Side Projects | 4305 | 104 |
571 | 3 | 6/25/2009 12:00:00 AM | 453056713 | Dave & Tim | Dave Side Projects | 4446 | 104 |
583 | 1 | 4/14/2009 12:00:00 AM | 453056612 | DMB | DMB | 4518 | 103 |
583 | 3 | 6/3/2017 12:00:00 AM | 453071415 | Dave & Tim | Dave Side Projects | 1546 | 5154 |
767 | 1 | 6/1/2013 12:00:00 AM | 453057090 | DMB | DMB | 3009 | 120 |
4873 | 1 | 5/7/2016 12:00:00 AM | 453067393 | DMB | DMB | 1938 | 2154 |
4873 | 2 | 6/6/2016 12:00:00 AM | 453067401 | Dave solo | Dave Side Projects | 1908 | 1154 |
4873 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 1878 | 1154 |
4873 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 1748 | 1154 |
4873 | 3058 | 11/1/2016 12:00:00 AM | 453068422 | Joshua Bell | Openers and Collaborators | 1760 | 1154 |
22033 | 1 | 8/13/2021 12:00:00 AM | 453089798 | DMB | DMB | 14 | 8164 |