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 = 453065432 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/26/2016' OR (SongInfo.ShowDate = '8/26/2016' AND SongInfo.ShowID < 453065432)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 401.1134
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
5 | 1 | 7/29/2016 12:00:00 AM | 453065430 | DMB | DMB | 28 | 2154 |
5 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 7439 | 31 |
5 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 51 | 1154 |
5 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 3856 | 86 |
11 | 1 | 7/27/2016 12:00:00 AM | 453065429 | DMB | DMB | 30 | 2154 |
11 | 2 | 6/9/2014 12:00:00 AM | 453057203 | Dave solo | Dave Side Projects | 809 | 122 |
11 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 51 | 1154 |
11 | 4 | 12/17/2003 12:00:00 AM | 453056049 | Dave & Friends | Dave Side Projects | 4636 | 76 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 8260 | 63 |
12 | 1 | 7/22/2016 12:00:00 AM | 453065426 | DMB | DMB | 35 | 2154 |
12 | 2 | 11/20/2002 12:00:00 AM | 453055947 | Dave solo | Dave Side Projects | 5028 | 32 |
12 | 3 | 1/16/2014 12:00:00 AM | 453057149 | Dave & Tim | Dave Side Projects | 953 | 122 |
27 | 1 | 7/22/2016 12:00:00 AM | 453065426 | DMB | DMB | 35 | 2154 |
27 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 7439 | 31 |
27 | 3 | 1/17/2015 12:00:00 AM | 453058208 | Dave & Tim | Dave Side Projects | 587 | 127 |
30 | 1 | 7/30/2016 12:00:00 AM | 453065431 | DMB | DMB | 27 | 2154 |
30 | 2 | 5/15/2006 12:00:00 AM | 453056320 | Dave solo | Dave Side Projects | 3756 | 86 |
30 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | Dave Side Projects | 6364 | 16 |
30 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 7925 | 52 |
33 | 1 | 7/16/2016 12:00:00 AM | 453065423 | DMB | DMB | 41 | 2154 |
33 | 3 | 2/21/1997 12:00:00 AM | 453054953 | Dave & Tim | Dave Side Projects | 7126 | 24 |
33 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 7805 | 41 |
41 | 1 | 7/29/2016 12:00:00 AM | 453065430 | DMB | DMB | 28 | 2154 |
41 | 2 | 9/2/2015 12:00:00 AM | 453064388 | Dave solo | Dave Side Projects | 359 | 127 |
41 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 51 | 1154 |
41 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 3856 | 86 |
41 | 8 | 3/13/2011 12:00:00 AM | 453056925 | Secret Stash | Stefan Side Projects | 1993 | 114 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 7424 | 31 |
56 | 1 | 7/27/2016 12:00:00 AM | 453065429 | DMB | DMB | 30 | 2154 |
56 | 3 | 1/23/1999 12:00:00 AM | 453054576 | Dave & Tim | Dave Side Projects | 6425 | 16 |
57 | 1 | 7/27/2016 12:00:00 AM | 453065429 | DMB | DMB | 30 | 2154 |
57 | 3 | 4/21/2007 12:00:00 AM | 453056465 | Dave & Tim | Dave Side Projects | 3415 | 93 |
57 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 3856 | 86 |
75 | 1 | 7/29/2016 12:00:00 AM | 453065430 | DMB | DMB | 28 | 2154 |
75 | 2 | 2/17/2012 12:00:00 AM | 453056972 | Dave solo | Dave Side Projects | 1652 | 116 |
75 | 3 | 1/17/2015 12:00:00 AM | 453058208 | Dave & Tim | Dave Side Projects | 587 | 127 |
83 | 1 | 7/23/2016 12:00:00 AM | 453065427 | DMB | DMB | 34 | 2154 |
90 | 2 | 5/10/2012 12:00:00 AM | 453057016 | Dave solo | Dave Side Projects | 1569 | 116 |
90 | 3 | 1/17/2015 12:00:00 AM | 453058208 | Dave & Tim | Dave Side Projects | 587 | 127 |
90 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 4304 | 79 |
90 | 74 | 9/7/2007 12:00:00 AM | 453063341 | Kenny Chesney | Openers and Collaborators | 3276 | 1146 |
90 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | Dave Side Projects | 4676 | 75 |
205 | 1 | 7/30/2016 12:00:00 AM | 453065431 | DMB | DMB | 27 | 2154 |
205 | 2 | 4/13/2011 12:00:00 AM | 453056930 | Dave solo | Dave Side Projects | 1962 | 114 |
205 | 3 | 1/17/2015 12:00:00 AM | 453058208 | Dave & Tim | Dave Side Projects | 587 | 127 |
205 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 3856 | 86 |
205 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 5101 | 32 |
205 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | Dave Side Projects | 4676 | 75 |
236 | 1 | 7/23/2016 12:00:00 AM | 453065427 | DMB | DMB | 34 | 2154 |
236 | 2 | 9/24/2011 12:00:00 AM | 453056962 | Dave solo | Dave Side Projects | 1798 | 114 |
236 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 51 | 1154 |
236 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 3856 | 86 |
301 | 1 | 7/29/2016 12:00:00 AM | 453065430 | DMB | DMB | 28 | 2154 |
440 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 51 | 1154 |
583 | 1 | 7/29/2016 12:00:00 AM | 453065430 | DMB | DMB | 28 | 2154 |
586 | 2 | 9/2/2015 12:00:00 AM | 453064388 | Dave solo | Dave Side Projects | 359 | 127 |
586 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 51 | 1154 |
4873 | 1 | 7/29/2016 12:00:00 AM | 453065430 | DMB | DMB | 28 | 2154 |
4873 | 2 | 6/6/2016 12:00:00 AM | 453067401 | Dave solo | Dave Side Projects | 81 | 1154 |
4873 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 51 | 1154 |
4875 | 1 | 7/27/2016 12:00:00 AM | 453065429 | DMB | DMB | 30 | 2154 |
4875 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 51 | 1154 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
5 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 9297 | 65 |
5 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 8882 | 57 |
5 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 8527 | 53 |
5 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 3856 | 86 |
11 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 9127 | 65 |
11 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 8750 | 57 |
11 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 8527 | 53 |
11 | 4 | 12/15/2003 12:00:00 AM | 453056047 | Dave & Friends | Dave Side Projects | 4638 | 76 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 8260 | 63 |
12 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 9127 | 65 |
12 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 8750 | 57 |
12 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 8527 | 53 |
27 | 1 | 6/9/1992 12:00:00 AM | 453055657 | DMB | DMB | 8844 | 56 |
27 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 7439 | 31 |
27 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 8475 | 53 |
30 | 1 | 11/17/1992 12:00:00 AM | 453055606 | DMB | DMB | 8683 | 56 |
30 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 8515 | 53 |
30 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 8527 | 53 |
30 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 7925 | 52 |
33 | 1 | 1/19/1993 12:00:00 AM | 453055496 | DMB | DMB | 8620 | 51 |
33 | 3 | 5/4/1994 12:00:00 AM | 453055404 | Dave & Tim | Dave Side Projects | 8150 | 52 |
33 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 7805 | 41 |
41 | 1 | 4/7/1995 12:00:00 AM | 453055187 | DMB | DMB | 7812 | 37 |
41 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 7439 | 31 |
41 | 3 | 2/1/1996 12:00:00 AM | 453054992 | Dave & Tim | Dave Side Projects | 7512 | 27 |
41 | 4 | 12/20/2003 12:00:00 AM | 453056051 | Dave & Friends | Dave Side Projects | 4633 | 76 |
41 | 8 | 3/13/2011 12:00:00 AM | 453056925 | Secret Stash | Stefan Side Projects | 1993 | 114 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 7424 | 31 |
56 | 1 | 11/29/1994 12:00:00 AM | 453055320 | DMB | DMB | 7941 | 45 |
56 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 6429 | 16 |
57 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 6705 | 23 |
57 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 6429 | 16 |
57 | 4 | 10/29/2005 12:00:00 AM | 453056234 | Dave & Friends | Dave Side Projects | 3954 | 84 |
75 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 5912 | 13 |
75 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 3758 | 86 |
75 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 4909 | 70 |
83 | 1 | 4/21/2001 12:00:00 AM | 2 | DMB | DMB | 5606 | 2 |
90 | 1 | 4/4/2002 12:00:00 AM | 453055751 | DMB | DMB | 5258 | 12 |
90 | 2 | 10/14/2001 12:00:00 AM | 57 | Dave solo | Dave Side Projects | 5430 | 1 |
90 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 4909 | 70 |
90 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 4640 | 76 |
90 | 74 | 9/7/2007 12:00:00 AM | 453063341 | Kenny Chesney | Openers and Collaborators | 3276 | 1146 |
90 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | Dave Side Projects | 4676 | 75 |
205 | 1 | 5/28/2002 12:00:00 AM | 453055851 | DMB | DMB | 5204 | 12 |
205 | 2 | 7/12/2002 12:00:00 AM | 453055902 | Dave solo | Dave Side Projects | 5159 | 66 |
205 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 4909 | 70 |
205 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 4641 | 76 |
205 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 5101 | 32 |
205 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | Dave Side Projects | 4676 | 75 |
236 | 1 | 6/1/2013 12:00:00 AM | 453057090 | DMB | DMB | 1182 | 120 |
236 | 2 | 1/9/2004 12:00:00 AM | 453056065 | Dave solo | Dave Side Projects | 4613 | 79 |
236 | 3 | 10/28/2005 12:00:00 AM | 453056235 | Dave & Tim | Dave Side Projects | 3955 | 84 |
236 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 4641 | 76 |
301 | 1 | 5/9/2005 12:00:00 AM | 453056223 | DMB | DMB | 4127 | 84 |
370 | 1 | 6/2/2006 12:00:00 AM | 453056268 | DMB | DMB | 3738 | 87 |
440 | 1 | 8/1/2007 12:00:00 AM | 453056468 | DMB | DMB | 3313 | 96 |
440 | 3 | 2/23/2007 12:00:00 AM | 453056398 | Dave & Tim | Dave Side Projects | 3472 | 91 |
583 | 1 | 4/14/2009 12:00:00 AM | 453056612 | DMB | DMB | 2691 | 103 |
586 | 1 | 6/6/2009 12:00:00 AM | 453056644 | DMB | DMB | 2638 | 106 |
586 | 2 | 11/13/2009 12:00:00 AM | 453056750 | Dave solo | Dave Side Projects | 2478 | 104 |
586 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | Dave Side Projects | 2608 | 104 |
4873 | 1 | 5/7/2016 12:00:00 AM | 453067393 | DMB | DMB | 111 | 2154 |
4873 | 2 | 6/6/2016 12:00:00 AM | 453067401 | Dave solo | Dave Side Projects | 81 | 1154 |
4873 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 51 | 1154 |
4875 | 1 | 5/7/2016 12:00:00 AM | 453067393 | DMB | DMB | 111 | 2154 |
4875 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 51 | 1154 |