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 = 453089747 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/3/2020' OR (SongInfo.ShowDate = '7/3/2020' AND SongInfo.ShowID < 453089747)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 281.8676
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
4 | 1 | 8/24/2019 12:00:00 AM | 453086606 | DMB | DMB | 314 | 7160 |
4 | 2 | 4/20/2018 12:00:00 AM | 453079538 | Dave solo | Dave Side Projects | 805 | 5156 |
4 | 3 | 2/15/2020 12:00:00 AM | 453089608 | Dave & Tim | Dave Side Projects | 139 | 8162 |
7 | 1 | 9/3/2016 12:00:00 AM | 453065437 | DMB | DMB | 1399 | 2154 |
7 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 10289 | 57 |
7 | 3 | 2/16/2019 12:00:00 AM | 453083554 | Dave & Tim | Dave Side Projects | 503 | 6158 |
7 | 4 | 1/12/2004 12:00:00 AM | 453056053 | Dave & Friends | Dave Side Projects | 6017 | 77 |
7 | 2025 | 10/18/2014 12:00:00 AM | 453062228 | Ladysmith Black Mambazo | Openers and Collaborators | 2085 | 1130 |
41 | 1 | 2/28/2020 12:00:00 AM | 453089627 | DMB | DMB | 126 | 8162 |
41 | 2 | 4/20/2018 12:00:00 AM | 453079538 | Dave solo | Dave Side Projects | 805 | 5156 |
41 | 3 | 2/14/2020 12:00:00 AM | 453089607 | Dave & Tim | Dave Side Projects | 140 | 8162 |
41 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 5263 | 86 |
41 | 8 | 2/1/2020 12:00:00 AM | 453089671 | Secret Stash | Stefan Side Projects | 153 | 8162 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 8831 | 31 |
41 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 1328 | 1154 |
42 | 1 | 9/10/2019 12:00:00 AM | 453089576 | DMB | DMB | 297 | 7160 |
42 | 3 | 1/14/2018 12:00:00 AM | 453074457 | Dave & Tim | Dave Side Projects | 901 | 5156 |
75 | 1 | 2/29/2020 12:00:00 AM | 453089616 | DMB | DMB | 125 | 8162 |
75 | 2 | 4/14/2020 12:00:00 AM | 453089680 | Dave solo | Dave Side Projects | 80 | 8166 |
75 | 3 | 2/14/2020 12:00:00 AM | 453089607 | Dave & Tim | Dave Side Projects | 140 | 8162 |
210 | 1 | 10/17/2015 12:00:00 AM | 453061211 | DMB | DMB | 1721 | 1129 |
210 | 2 | 7/15/2019 12:00:00 AM | 453089575 | Dave solo | Dave Side Projects | 354 | 6158 |
210 | 3 | 2/15/2020 12:00:00 AM | 453089608 | Dave & Tim | Dave Side Projects | 139 | 8162 |
210 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 6508 | 32 |
304 | 1 | 10/3/2019 12:00:00 AM | 453089596 | DMB | DMB | 274 | 8161 |
304 | 2 | 7/15/2019 12:00:00 AM | 453089575 | Dave solo | Dave Side Projects | 354 | 6158 |
304 | 3 | 2/14/2020 12:00:00 AM | 453089607 | Dave & Tim | Dave Side Projects | 140 | 8162 |
586 | 1 | 2/29/2020 12:00:00 AM | 453089616 | DMB | DMB | 125 | 8162 |
586 | 2 | 9/11/2019 12:00:00 AM | 453089611 | Dave solo | Dave Side Projects | 296 | 6158 |
586 | 3 | 2/15/2020 12:00:00 AM | 453089608 | Dave & Tim | Dave Side Projects | 139 | 8162 |
693 | 1 | 9/13/2015 12:00:00 AM | 453060252 | DMB | DMB | 1755 | 128 |
693 | 2 | 5/19/2020 12:00:00 AM | 453089734 | Dave solo | Dave Side Projects | 45 | 8166 |
693 | 3 | 1/14/2018 12:00:00 AM | 453074457 | Dave & Tim | Dave Side Projects | 901 | 5156 |
4873 | 1 | 2/29/2020 12:00:00 AM | 453089616 | DMB | DMB | 125 | 8162 |
4873 | 2 | 9/11/2019 12:00:00 AM | 453089611 | Dave solo | Dave Side Projects | 296 | 6158 |
4873 | 3 | 2/14/2020 12:00:00 AM | 453089607 | Dave & Tim | Dave Side Projects | 140 | 8162 |
4873 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 1328 | 1154 |
4873 | 3058 | 11/1/2016 12:00:00 AM | 453068422 | Joshua Bell | Openers and Collaborators | 1340 | 1154 |
4877 | 1 | 10/8/2019 12:00:00 AM | 453089598 | DMB | DMB | 269 | 8161 |
4877 | 2 | 9/19/2018 12:00:00 AM | 453083559 | Dave solo | Dave Side Projects | 653 | 5156 |
4877 | 3 | 2/16/2020 12:00:00 AM | 453089609 | Dave & Tim | Dave Side Projects | 138 | 8162 |
4877 | 3058 | 11/1/2016 12:00:00 AM | 453068422 | Joshua Bell | Openers and Collaborators | 1340 | 1154 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
4 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 10704 | 65 |
4 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 10289 | 57 |
4 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 9934 | 53 |
7 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 10704 | 65 |
7 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 10289 | 57 |
7 | 3 | 2/21/1994 12:00:00 AM | 453055428 | Dave & Tim | Dave Side Projects | 9629 | 52 |
7 | 4 | 12/20/2003 12:00:00 AM | 453056051 | Dave & Friends | Dave Side Projects | 6040 | 76 |
7 | 2025 | 10/18/2014 12:00:00 AM | 453062228 | Ladysmith Black Mambazo | Openers and Collaborators | 2085 | 1130 |
41 | 1 | 4/7/1995 12:00:00 AM | 453055187 | DMB | DMB | 9219 | 37 |
41 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 8846 | 31 |
41 | 3 | 2/1/1996 12:00:00 AM | 453054992 | Dave & Tim | Dave Side Projects | 8919 | 27 |
41 | 4 | 12/20/2003 12:00:00 AM | 453056051 | Dave & Friends | Dave Side Projects | 6040 | 76 |
41 | 8 | 3/13/2011 12:00:00 AM | 453056925 | Secret Stash | Stefan Side Projects | 3400 | 114 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 8831 | 31 |
41 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 1328 | 1154 |
42 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 8112 | 23 |
42 | 3 | 6/3/2017 12:00:00 AM | 453071415 | Dave & Tim | Dave Side Projects | 1126 | 5154 |
75 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 7319 | 13 |
75 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 5165 | 86 |
75 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 6316 | 70 |
210 | 1 | 7/5/2002 12:00:00 AM | 453055813 | DMB | DMB | 6573 | 58 |
210 | 2 | 10/24/2002 12:00:00 AM | 453055916 | Dave solo | Dave Side Projects | 6462 | 32 |
210 | 3 | 7/28/2007 12:00:00 AM | 453056507 | Dave & Tim | Dave Side Projects | 4724 | 93 |
210 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 6508 | 32 |
304 | 1 | 5/30/2006 12:00:00 AM | 453056266 | DMB | DMB | 5148 | 87 |
304 | 2 | 5/11/2006 12:00:00 AM | 453056332 | Dave solo | Dave Side Projects | 5167 | 86 |
304 | 3 | 10/27/2006 12:00:00 AM | 453056382 | Dave & Tim | Dave Side Projects | 4998 | 86 |
586 | 1 | 6/6/2009 12:00:00 AM | 453056644 | DMB | DMB | 4045 | 106 |
586 | 2 | 11/13/2009 12:00:00 AM | 453056750 | Dave solo | Dave Side Projects | 3885 | 104 |
586 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | Dave Side Projects | 4015 | 104 |
693 | 1 | 7/8/2011 12:00:00 AM | 453056922 | DMB | DMB | 3283 | 115 |
693 | 2 | 10/14/2011 12:00:00 AM | 453056963 | Dave solo | Dave Side Projects | 3185 | 114 |
693 | 3 | 8/20/2011 12:00:00 AM | 453056946 | Dave & Tim | Dave Side Projects | 3240 | 114 |
4873 | 1 | 5/7/2016 12:00:00 AM | 453067393 | DMB | DMB | 1518 | 2154 |
4873 | 2 | 6/6/2016 12:00:00 AM | 453067401 | Dave solo | Dave Side Projects | 1488 | 1154 |
4873 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 1458 | 1154 |
4873 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 1328 | 1154 |
4873 | 3058 | 11/1/2016 12:00:00 AM | 453068422 | Joshua Bell | Openers and Collaborators | 1340 | 1154 |
4877 | 1 | 7/1/2018 12:00:00 AM | 453079497 | DMB | DMB | 733 | 6156 |
4877 | 2 | 6/11/2018 12:00:00 AM | 453080545 | Dave solo | Dave Side Projects | 753 | 5156 |
4877 | 3 | 6/26/2018 12:00:00 AM | 453079540 | Dave & Tim | Dave Side Projects | 738 | 5156 |
4877 | 3058 | 11/1/2016 12:00:00 AM | 453068422 | Joshua Bell | Openers and Collaborators | 1340 | 1154 |