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 = 453089893 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/12/2022' OR (SongInfo.ShowDate = '7/12/2022' AND SongInfo.ShowID < 453089893)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 449.2399
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
5 | 1 | 7/9/2022 12:00:00 AM | 453089892 | DMB | DMB | 3 | 8169 |
5 | 2 | 3/26/2022 12:00:00 AM | 453090916 | Dave solo | Dave Side Projects | 108 | 8167 |
5 | 3 | 2/20/2022 12:00:00 AM | 453089833 | Dave & Tim | Dave Side Projects | 142 | 8167 |
5 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 6002 | 86 |
12 | 1 | 6/25/2022 12:00:00 AM | 453089886 | DMB | DMB | 17 | 8169 |
12 | 2 | 10/2/2020 12:00:00 AM | 453089767 | Dave solo | Dave Side Projects | 648 | 8166 |
12 | 3 | 2/20/2022 12:00:00 AM | 453089833 | Dave & Tim | Dave Side Projects | 142 | 8167 |
17 | 1 | 7/9/2022 12:00:00 AM | 453089892 | DMB | DMB | 3 | 8169 |
17 | 2 | 4/9/2022 12:00:00 AM | 453090920 | Dave solo | Dave Side Projects | 94 | 8167 |
17 | 3 | 2/20/2022 12:00:00 AM | 453089833 | Dave & Tim | Dave Side Projects | 142 | 8167 |
17 | 4 | 12/19/2003 12:00:00 AM | 453056050 | Dave & Friends | Dave Side Projects | 6780 | 76 |
17 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 2067 | 1154 |
17 | 3058 | 11/1/2016 12:00:00 AM | 453068422 | Joshua Bell | Openers and Collaborators | 2079 | 1154 |
17 | 9090 | 8/13/2021 12:00:00 AM | 453089840 | The Cadets | Openers and Collaborators | 333 | 8168 |
19 | 1 | 7/3/2022 12:00:00 AM | 453089890 | DMB | DMB | 9 | 8169 |
19 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 9585 | 31 |
19 | 3 | 2/18/2022 12:00:00 AM | 453089831 | Dave & Tim | Dave Side Projects | 144 | 8167 |
19 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 6002 | 86 |
19 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 9570 | 31 |
30 | 1 | 7/3/2022 12:00:00 AM | 453089890 | DMB | DMB | 9 | 8169 |
30 | 2 | 3/26/2022 12:00:00 AM | 453090916 | Dave solo | Dave Side Projects | 108 | 8167 |
30 | 3 | 2/19/2022 12:00:00 AM | 453089832 | Dave & Tim | Dave Side Projects | 143 | 8167 |
30 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 10071 | 52 |
41 | 1 | 7/8/2022 12:00:00 AM | 453089891 | DMB | DMB | 4 | 8169 |
41 | 2 | 7/3/2020 12:00:00 AM | 453089747 | Dave solo | Dave Side Projects | 739 | 8166 |
41 | 3 | 2/18/2022 12:00:00 AM | 453089831 | Dave & Tim | Dave Side Projects | 144 | 8167 |
41 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 6002 | 86 |
41 | 8 | 2/1/2020 12:00:00 AM | 453089671 | Secret Stash | Stefan Side Projects | 892 | 8162 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 9570 | 31 |
41 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 2067 | 1154 |
49 | 1 | 7/8/2022 12:00:00 AM | 453089891 | DMB | DMB | 4 | 8169 |
49 | 2 | 6/30/2022 12:00:00 AM | 453090930 | Dave solo | Dave Side Projects | 12 | 8167 |
49 | 3 | 2/20/2022 12:00:00 AM | 453089833 | Dave & Tim | Dave Side Projects | 142 | 8167 |
49 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 6786 | 76 |
49 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 2067 | 1154 |
56 | 1 | 7/2/2022 12:00:00 AM | 453089889 | DMB | DMB | 10 | 8169 |
56 | 3 | 2/20/2022 12:00:00 AM | 453089833 | Dave & Tim | Dave Side Projects | 142 | 8167 |
57 | 1 | 7/2/2022 12:00:00 AM | 453089889 | DMB | DMB | 10 | 8169 |
57 | 3 | 9/24/2019 12:00:00 AM | 453089617 | Dave & Tim | Dave Side Projects | 1022 | 6158 |
57 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 6002 | 86 |
75 | 1 | 7/8/2022 12:00:00 AM | 453089891 | DMB | DMB | 4 | 8169 |
75 | 2 | 5/22/2022 12:00:00 AM | 453090923 | Dave solo | Dave Side Projects | 51 | 8167 |
75 | 3 | 2/18/2022 12:00:00 AM | 453089831 | Dave & Tim | Dave Side Projects | 144 | 8167 |
75 | 13 | 11/19/2020 12:00:00 AM | 453089784 | Dave & Carter | DMB | 600 | 8166 |
77 | 1 | 7/2/2022 12:00:00 AM | 453089889 | DMB | DMB | 10 | 8169 |
77 | 2 | 11/13/2001 12:00:00 AM | 62 | Dave solo | Dave Side Projects | 7546 | 1 |
77 | 3 | 2/19/2022 12:00:00 AM | 453089832 | Dave & Tim | Dave Side Projects | 143 | 8167 |
83 | 1 | 7/8/2022 12:00:00 AM | 453089891 | DMB | DMB | 4 | 8169 |
96 | 2 | 3/26/2022 12:00:00 AM | 453090916 | Dave solo | Dave Side Projects | 108 | 8167 |
96 | 3 | 2/19/2022 12:00:00 AM | 453089832 | Dave & Tim | Dave Side Projects | 143 | 8167 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 10686 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | Openers and Collaborators | 10749 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 10309 | 1133 |
96 | 45 | 4/30/2005 12:00:00 AM | 453086573 | Gov't Mule | Openers and Collaborators | 6282 | 1144 |
96 | 63 | 6/30/2004 12:00:00 AM | 453063318 | Keller Williams | Openers and Collaborators | 6586 | 1143 |
96 | 80 | 8/20/2011 12:00:00 AM | 453063351 | Warren Haynes Band | Openers and Collaborators | 3979 | 1149 |
96 | 85 | 2/26/2016 12:00:00 AM | 453066392 | Phil & Friends | Openers and Collaborators | 2328 | 2155 |
255 | 1 | 7/8/2022 12:00:00 AM | 453089891 | DMB | DMB | 4 | 8169 |
255 | 4 | 1/15/2004 12:00:00 AM | 453056055 | Dave & Friends | Dave Side Projects | 6753 | 77 |
255 | 7 | 12/10/2011 12:00:00 AM | 453056970 | Yukon Kornelius | Stefan Side Projects | 3867 | 114 |
584 | 1 | 7/8/2022 12:00:00 AM | 453089891 | DMB | DMB | 4 | 8169 |
586 | 2 | 3/26/2022 12:00:00 AM | 453090916 | Dave solo | Dave Side Projects | 108 | 8167 |
586 | 3 | 2/19/2022 12:00:00 AM | 453089832 | Dave & Tim | Dave Side Projects | 143 | 8167 |
590 | 1 | 7/2/2022 12:00:00 AM | 453089889 | DMB | DMB | 10 | 8169 |
590 | 2 | 9/26/2020 12:00:00 AM | 453089763 | Dave solo | Dave Side Projects | 654 | 8166 |
590 | 3 | 1/28/2018 12:00:00 AM | 453079475 | Dave & Tim | Dave Side Projects | 1626 | 5156 |
4890 | 85 | 2/26/2016 12:00:00 AM | 453066392 | Phil & Friends | Openers and Collaborators | 2328 | 2155 |
16941 | 1 | 7/3/2022 12:00:00 AM | 453089890 | DMB | DMB | 9 | 8169 |
16941 | 9089 | 6/20/2020 12:00:00 AM | 453089745 | Dave & Preservation Hall Jazz Band | Dave Side Projects | 752 | 8166 |
16947 | 1 | 7/9/2022 12:00:00 AM | 453089892 | DMB | DMB | 3 | 8169 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
5 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 11443 | 65 |
5 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 11028 | 57 |
5 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 10673 | 53 |
5 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 6002 | 86 |
12 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 11273 | 65 |
12 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 10896 | 57 |
12 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 10673 | 53 |
17 | 1 | 10/22/1991 12:00:00 AM | 453055864 | DMB | DMB | 11221 | 65 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 10896 | 57 |
17 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 10673 | 53 |
17 | 4 | 12/19/2003 12:00:00 AM | 453056050 | Dave & Friends | Dave Side Projects | 6780 | 76 |
17 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 2067 | 1154 |
17 | 3058 | 11/1/2016 12:00:00 AM | 453068422 | Joshua Bell | Openers and Collaborators | 2079 | 1154 |
17 | 9090 | 8/13/2021 12:00:00 AM | 453089840 | The Cadets | Openers and Collaborators | 333 | 8168 |
19 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 11273 | 65 |
19 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 9585 | 31 |
19 | 3 | 9/26/1994 12:00:00 AM | 453055276 | Dave & Tim | Dave Side Projects | 10151 | 52 |
19 | 4 | 10/29/2005 12:00:00 AM | 453056234 | Dave & Friends | Dave Side Projects | 6100 | 84 |
19 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 10071 | 52 |
30 | 1 | 11/17/1992 12:00:00 AM | 453055606 | DMB | DMB | 10829 | 56 |
30 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 10661 | 53 |
30 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 10673 | 53 |
30 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 10071 | 52 |
41 | 1 | 4/7/1995 12:00:00 AM | 453055187 | DMB | DMB | 9958 | 37 |
41 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 9585 | 31 |
41 | 3 | 2/1/1996 12:00:00 AM | 453054992 | Dave & Tim | Dave Side Projects | 9658 | 27 |
41 | 4 | 12/20/2003 12:00:00 AM | 453056051 | Dave & Friends | Dave Side Projects | 6779 | 76 |
41 | 8 | 3/13/2011 12:00:00 AM | 453056925 | Secret Stash | Stefan Side Projects | 4139 | 114 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 9570 | 31 |
41 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 2067 | 1154 |
49 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 8851 | 23 |
49 | 2 | 7/1/1998 12:00:00 AM | 453056508 | Dave solo | Dave Side Projects | 8777 | 23 |
49 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 8575 | 16 |
49 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 6786 | 76 |
49 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 2067 | 1154 |
56 | 1 | 11/29/1994 12:00:00 AM | 453055320 | DMB | DMB | 10087 | 45 |
56 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 8575 | 16 |
57 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 8851 | 23 |
57 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 8575 | 16 |
57 | 4 | 10/29/2005 12:00:00 AM | 453056234 | Dave & Friends | Dave Side Projects | 6100 | 84 |
75 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 8058 | 13 |
75 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 5904 | 86 |
75 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 7055 | 70 |
75 | 13 | 11/19/2020 12:00:00 AM | 453089784 | Dave & Carter | DMB | 600 | 8166 |
77 | 1 | 4/21/2001 12:00:00 AM | 2 | DMB | DMB | 7752 | 2 |
77 | 2 | 5/26/2001 12:00:00 AM | 453055807 | Dave solo | Dave Side Projects | 7717 | 1 |
77 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 7055 | 70 |
83 | 1 | 4/21/2001 12:00:00 AM | 2 | DMB | DMB | 7752 | 2 |
96 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 11273 | 65 |
96 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 11028 | 57 |
96 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 10673 | 53 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 10686 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | Openers and Collaborators | 10749 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 10309 | 1133 |
96 | 45 | 4/30/2005 12:00:00 AM | 453086573 | Gov't Mule | Openers and Collaborators | 6282 | 1144 |
96 | 63 | 6/30/2004 12:00:00 AM | 453063318 | Keller Williams | Openers and Collaborators | 6586 | 1143 |
96 | 80 | 8/20/2011 12:00:00 AM | 453063351 | Warren Haynes Band | Openers and Collaborators | 3979 | 1149 |
96 | 85 | 9/27/2015 12:00:00 AM | 453064390 | Phil & Friends | Openers and Collaborators | 2480 | 1153 |
255 | 1 | 7/2/2022 12:00:00 AM | 453089889 | DMB | DMB | 10 | 8169 |
255 | 4 | 12/17/2003 12:00:00 AM | 453056049 | Dave & Friends | Dave Side Projects | 6782 | 76 |
255 | 7 | 12/10/2011 12:00:00 AM | 453056970 | Yukon Kornelius | Stefan Side Projects | 3867 | 114 |
584 | 1 | 5/5/2009 12:00:00 AM | 453056624 | DMB | DMB | 4816 | 103 |
586 | 1 | 6/6/2009 12:00:00 AM | 453056644 | DMB | DMB | 4784 | 106 |
586 | 2 | 11/13/2009 12:00:00 AM | 453056750 | Dave solo | Dave Side Projects | 4624 | 104 |
586 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | Dave Side Projects | 4754 | 104 |
590 | 1 | 4/29/2009 12:00:00 AM | 453056621 | DMB | DMB | 4822 | 103 |
590 | 2 | 5/3/2009 12:00:00 AM | 453056685 | Dave solo | Dave Side Projects | 4818 | 104 |
590 | 3 | 12/11/2009 12:00:00 AM | 453056730 | Dave & Tim | Dave Side Projects | 4596 | 104 |
4890 | 85 | 2/26/2016 12:00:00 AM | 453066392 | Phil & Friends | Openers and Collaborators | 2328 | 2155 |
16941 | 1 | 5/26/2018 12:00:00 AM | 453079479 | DMB | DMB | 1508 | 6156 |
16941 | 9089 | 6/20/2020 12:00:00 AM | 453089745 | Dave & Preservation Hall Jazz Band | Dave Side Projects | 752 | 8166 |
16947 | 1 | 6/15/2018 12:00:00 AM | 453079490 | DMB | DMB | 1488 | 6156 |
22104 | 1 | 11/5/2021 12:00:00 AM | 453089838 | DMB | DMB | 249 | 8164 |