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 = 453089794 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/24/2021' OR (SongInfo.ShowDate = '7/24/2021' AND SongInfo.ShowID < 453089794)) 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 |
6 | 1 | 10/19/2019 12:00:00 AM | 453089619 | DMB | DMB | 644 | 6158 |
6 | 2 | 4/16/2021 12:00:00 AM | 453089792 | Dave solo | Dave Side Projects | 99 | 8165 |
6 | 3 | 2/15/2020 12:00:00 AM | 453089608 | Dave & Tim | Dave Side Projects | 525 | 8162 |
6 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 9598 | 41 |
11 | 1 | 10/19/2019 12:00:00 AM | 453089619 | DMB | DMB | 644 | 6158 |
11 | 2 | 4/22/2021 12:00:00 AM | 453089826 | Dave solo | Dave Side Projects | 93 | 8165 |
11 | 3 | 2/14/2020 12:00:00 AM | 453089607 | Dave & Tim | Dave Side Projects | 526 | 8162 |
11 | 4 | 12/17/2003 12:00:00 AM | 453056049 | Dave & Friends | Dave Side Projects | 6429 | 76 |
11 | 13 | 11/19/2020 12:00:00 AM | 453089784 | Dave & Carter | DMB | 247 | 8166 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 10053 | 63 |
21 | 1 | 2/29/2020 12:00:00 AM | 453089616 | DMB | DMB | 511 | 8162 |
21 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 5551 | 86 |
21 | 3 | 2/16/2020 12:00:00 AM | 453089609 | Dave & Tim | Dave Side Projects | 524 | 8162 |
27 | 1 | 8/30/2019 12:00:00 AM | 453086608 | DMB | DMB | 694 | 7160 |
27 | 2 | 10/2/2020 12:00:00 AM | 453089767 | Dave solo | Dave Side Projects | 295 | 8166 |
27 | 3 | 4/7/2017 12:00:00 AM | 453069424 | Dave & Tim | Dave Side Projects | 1569 | 4154 |
44 | 1 | 9/1/2019 12:00:00 AM | 453086610 | DMB | DMB | 692 | 7160 |
44 | 2 | 5/15/2020 12:00:00 AM | 453089733 | Dave solo | Dave Side Projects | 435 | 8166 |
44 | 3 | 6/10/2017 12:00:00 AM | 453071419 | Dave & Tim | Dave Side Projects | 1505 | 5154 |
47 | 1 | 2/29/2020 12:00:00 AM | 453089616 | DMB | DMB | 511 | 8162 |
47 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 5551 | 86 |
47 | 3 | 2/16/2020 12:00:00 AM | 453089609 | Dave & Tim | Dave Side Projects | 524 | 8162 |
47 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 5649 | 86 |
47 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 9217 | 31 |
49 | 1 | 2/29/2020 12:00:00 AM | 453089616 | DMB | DMB | 511 | 8162 |
49 | 2 | 9/26/2020 12:00:00 AM | 453089763 | Dave solo | Dave Side Projects | 301 | 8166 |
49 | 3 | 2/15/2020 12:00:00 AM | 453089608 | Dave & Tim | Dave Side Projects | 525 | 8162 |
49 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 6433 | 76 |
49 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 1714 | 1154 |
67 | 1 | 2/29/2020 12:00:00 AM | 453089616 | DMB | DMB | 511 | 8162 |
67 | 4 | 1/16/2004 12:00:00 AM | 453056056 | Dave & Friends | Dave Side Projects | 6399 | 77 |
69 | 1 | 9/1/2019 12:00:00 AM | 453086610 | DMB | DMB | 692 | 7160 |
69 | 2 | 4/16/2021 12:00:00 AM | 453089792 | Dave solo | Dave Side Projects | 99 | 8165 |
69 | 3 | 2/17/2019 12:00:00 AM | 453083556 | Dave & Tim | Dave Side Projects | 888 | 6158 |
69 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 9472 | 41 |
77 | 1 | 6/7/2018 12:00:00 AM | 453079486 | DMB | DMB | 1143 | 6156 |
77 | 2 | 11/13/2001 12:00:00 AM | 62 | Dave solo | Dave Side Projects | 7193 | 1 |
77 | 3 | 6/18/2019 12:00:00 AM | 453089574 | Dave & Tim | Dave Side Projects | 767 | 6158 |
80 | 1 | 10/20/2019 12:00:00 AM | 453089613 | DMB | DMB | 643 | 6158 |
80 | 2 | 4/15/2021 12:00:00 AM | 453089793 | Dave solo | Dave Side Projects | 100 | 8165 |
80 | 3 | 6/18/2019 12:00:00 AM | 453089574 | Dave & Tim | Dave Side Projects | 767 | 6158 |
90 | 1 | 10/19/2019 12:00:00 AM | 453089619 | DMB | DMB | 644 | 6158 |
90 | 2 | 4/16/2021 12:00:00 AM | 453089792 | Dave solo | Dave Side Projects | 99 | 8165 |
90 | 3 | 2/16/2020 12:00:00 AM | 453089609 | Dave & Tim | Dave Side Projects | 524 | 8162 |
90 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 6097 | 79 |
90 | 74 | 9/7/2007 12:00:00 AM | 453063341 | Kenny Chesney | Openers and Collaborators | 5069 | 1146 |
90 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | Dave Side Projects | 6469 | 75 |
92 | 1 | 2/29/2020 12:00:00 AM | 453089616 | DMB | DMB | 511 | 8162 |
202 | 2 | 4/16/2021 12:00:00 AM | 453089792 | Dave solo | Dave Side Projects | 99 | 8165 |
571 | 1 | 2/28/2020 12:00:00 AM | 453089627 | DMB | DMB | 512 | 8162 |
571 | 2 | 7/28/2011 12:00:00 AM | 453056947 | Dave solo | Dave Side Projects | 3649 | 114 |
571 | 3 | 2/15/2020 12:00:00 AM | 453089608 | Dave & Tim | Dave Side Projects | 525 | 8162 |
574 | 1 | 10/20/2019 12:00:00 AM | 453089613 | DMB | DMB | 643 | 6158 |
574 | 3 | 12/11/2010 12:00:00 AM | 453056859 | Dave & Tim | Dave Side Projects | 3878 | 113 |
577 | 1 | 9/10/2019 12:00:00 AM | 453089576 | DMB | DMB | 683 | 7160 |
577 | 2 | 12/11/2009 12:00:00 AM | 453056757 | Dave solo | Dave Side Projects | 4243 | 104 |
577 | 3 | 2/16/2020 12:00:00 AM | 453089609 | Dave & Tim | Dave Side Projects | 524 | 8162 |
579 | 1 | 10/18/2019 12:00:00 AM | 453089612 | DMB | DMB | 645 | 6158 |
579 | 2 | 9/19/2018 12:00:00 AM | 453083559 | Dave solo | Dave Side Projects | 1039 | 5156 |
579 | 3 | 2/14/2020 12:00:00 AM | 453089607 | Dave & Tim | Dave Side Projects | 526 | 8162 |
584 | 1 | 7/26/2019 12:00:00 AM | 453086603 | DMB | DMB | 729 | 7160 |
586 | 2 | 9/30/2020 12:00:00 AM | 453089765 | Dave solo | Dave Side Projects | 297 | 8166 |
586 | 3 | 2/15/2020 12:00:00 AM | 453089608 | Dave & Tim | Dave Side Projects | 525 | 8162 |
726 | 1 | 8/27/2016 12:00:00 AM | 453065433 | DMB | DMB | 1792 | 2154 |
726 | 2 | 10/27/2013 12:00:00 AM | 453057153 | Dave solo | Dave Side Projects | 2827 | 119 |
726 | 3 | 6/7/2017 12:00:00 AM | 453071418 | Dave & Tim | Dave Side Projects | 1508 | 5154 |
732 | 1 | 9/13/2019 12:00:00 AM | 453086612 | DMB | DMB | 680 | 7160 |
732 | 2 | 4/16/2021 12:00:00 AM | 453089792 | Dave solo | Dave Side Projects | 99 | 8165 |
732 | 3 | 2/16/2020 12:00:00 AM | 453089609 | Dave & Tim | Dave Side Projects | 524 | 8162 |
22000 | 2 | 6/4/2021 12:00:00 AM | 453089834 | Dave solo | Dave Side Projects | 50 | 8165 |
22023 | 1 | 7/23/2021 12:00:00 AM | 453089708 | DMB | DMB | 1 | 8164 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
6 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 10920 | 65 |
6 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 10543 | 57 |
6 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 10320 | 53 |
6 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 10053 | 63 |
11 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 10920 | 65 |
11 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 10543 | 57 |
11 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 10320 | 53 |
11 | 4 | 12/15/2003 12:00:00 AM | 453056047 | Dave & Friends | Dave Side Projects | 6431 | 76 |
11 | 13 | 11/19/2020 12:00:00 AM | 453089784 | Dave & Carter | DMB | 247 | 8166 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 10053 | 63 |
21 | 1 | 2/13/1992 12:00:00 AM | 453055738 | DMB | DMB | 10754 | 56 |
21 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 10543 | 57 |
21 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 10320 | 53 |
27 | 1 | 6/9/1992 12:00:00 AM | 453055657 | DMB | DMB | 10637 | 56 |
27 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 9232 | 31 |
27 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 10268 | 53 |
44 | 1 | 12/16/1994 12:00:00 AM | 453056378 | DMB | DMB | 9717 | 45 |
44 | 2 | 5/15/2020 12:00:00 AM | 453089733 | Dave solo | Dave Side Projects | 435 | 8166 |
44 | 3 | 2/8/1996 12:00:00 AM | 453054997 | Dave & Tim | Dave Side Projects | 9298 | 27 |
47 | 1 | 10/4/1995 12:00:00 AM | 453055261 | DMB | DMB | 9425 | 41 |
47 | 2 | 3/8/1999 12:00:00 AM | 453054607 | Dave solo | Dave Side Projects | 8174 | 62 |
47 | 3 | 12/16/1996 12:00:00 AM | 453055128 | Dave & Tim | Dave Side Projects | 8986 | 31 |
47 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 6433 | 76 |
47 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 9217 | 31 |
49 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 8498 | 23 |
49 | 2 | 7/1/1998 12:00:00 AM | 453056508 | Dave solo | Dave Side Projects | 8424 | 23 |
49 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 8222 | 16 |
49 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 6433 | 76 |
49 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 1714 | 1154 |
67 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 7705 | 13 |
67 | 4 | 12/17/2003 12:00:00 AM | 453056049 | Dave & Friends | Dave Side Projects | 6429 | 76 |
69 | 1 | 8/20/1995 12:00:00 AM | 453055247 | DMB | DMB | 9470 | 38 |
69 | 2 | 10/24/2002 12:00:00 AM | 453055916 | Dave solo | Dave Side Projects | 6848 | 32 |
69 | 3 | 7/15/2012 12:00:00 AM | 453057034 | Dave & Tim | Dave Side Projects | 3296 | 116 |
69 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 9472 | 41 |
77 | 1 | 4/21/2001 12:00:00 AM | 2 | DMB | DMB | 7399 | 2 |
77 | 2 | 5/26/2001 12:00:00 AM | 453055807 | Dave solo | Dave Side Projects | 7364 | 1 |
77 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 6702 | 70 |
80 | 1 | 2/24/2001 12:00:00 AM | 453055934 | DMB | DMB | 7455 | 1 |
80 | 2 | 2/23/2001 12:00:00 AM | 453055792 | Dave solo | Dave Side Projects | 7456 | 33 |
80 | 3 | 7/15/2012 12:00:00 AM | 453057034 | Dave & Tim | Dave Side Projects | 3296 | 116 |
90 | 1 | 4/4/2002 12:00:00 AM | 453055751 | DMB | DMB | 7051 | 12 |
90 | 2 | 10/14/2001 12:00:00 AM | 57 | Dave solo | Dave Side Projects | 7223 | 1 |
90 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 6702 | 70 |
90 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 6433 | 76 |
90 | 74 | 9/7/2007 12:00:00 AM | 453063341 | Kenny Chesney | Openers and Collaborators | 5069 | 1146 |
90 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | Dave Side Projects | 6469 | 75 |
92 | 1 | 10/3/1996 12:00:00 AM | 453055078 | DMB | DMB | 9060 | 29 |
202 | 1 | 4/7/2002 12:00:00 AM | 453055753 | DMB | DMB | 7048 | 12 |
202 | 2 | 4/16/2021 12:00:00 AM | 453089792 | Dave solo | Dave Side Projects | 99 | 8165 |
571 | 1 | 6/6/2009 12:00:00 AM | 453056644 | DMB | DMB | 4431 | 106 |
571 | 2 | 11/13/2009 12:00:00 AM | 453056750 | Dave solo | Dave Side Projects | 4271 | 104 |
571 | 3 | 6/25/2009 12:00:00 AM | 453056713 | Dave & Tim | Dave Side Projects | 4412 | 104 |
574 | 1 | 6/12/2009 12:00:00 AM | 453056651 | DMB | DMB | 4425 | 106 |
574 | 3 | 12/10/2009 12:00:00 AM | 453056729 | Dave & Tim | Dave Side Projects | 4244 | 104 |
577 | 1 | 5/29/2009 12:00:00 AM | 453056641 | DMB | DMB | 4439 | 106 |
577 | 2 | 12/11/2009 12:00:00 AM | 453056757 | Dave solo | Dave Side Projects | 4243 | 104 |
577 | 3 | 12/11/2009 12:00:00 AM | 453056730 | Dave & Tim | Dave Side Projects | 4243 | 104 |
579 | 1 | 4/14/2009 12:00:00 AM | 453056612 | DMB | DMB | 4484 | 103 |
579 | 2 | 8/26/2011 12:00:00 AM | 453056953 | Dave solo | Dave Side Projects | 3620 | 114 |
579 | 3 | 6/25/2009 12:00:00 AM | 453056713 | Dave & Tim | Dave Side Projects | 4412 | 104 |
584 | 1 | 5/5/2009 12:00:00 AM | 453056624 | DMB | DMB | 4463 | 103 |
586 | 1 | 6/6/2009 12:00:00 AM | 453056644 | DMB | DMB | 4431 | 106 |
586 | 2 | 11/13/2009 12:00:00 AM | 453056750 | Dave solo | Dave Side Projects | 4271 | 104 |
586 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | Dave Side Projects | 4401 | 104 |
726 | 1 | 6/3/2012 12:00:00 AM | 453056983 | DMB | DMB | 3338 | 117 |
726 | 2 | 10/27/2013 12:00:00 AM | 453057153 | Dave solo | Dave Side Projects | 2827 | 119 |
726 | 3 | 9/21/2013 12:00:00 AM | 453057134 | Dave & Tim | Dave Side Projects | 2863 | 119 |
732 | 1 | 9/8/2012 12:00:00 AM | 453057012 | DMB | DMB | 3241 | 117 |
732 | 2 | 4/16/2021 12:00:00 AM | 453089792 | Dave solo | Dave Side Projects | 99 | 8165 |
732 | 3 | 2/24/2017 12:00:00 AM | 453067416 | Dave & Tim | Dave Side Projects | 1611 | 3154 |
22000 | 2 | 3/26/2020 12:00:00 AM | 453089677 | Dave solo | Dave Side Projects | 485 | 8166 |
22023 | 1 | 7/23/2021 12:00:00 AM | 453089708 | DMB | DMB | 1 | 8164 |