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 = 453065420 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/2016' OR (SongInfo.ShowDate = '7/12/2016' AND SongInfo.ShowID < 453065420)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 407.2514
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
5 | 1 | 7/9/2016 12:00:00 AM | 453065419 | DMB | DMB | 3 | 2154 |
5 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 7394 | 31 |
5 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 6 | 1154 |
5 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 3811 | 86 |
6 | 1 | 7/1/2016 12:00:00 AM | 453065416 | DMB | DMB | 11 | 2154 |
6 | 2 | 5/12/2006 12:00:00 AM | 453056318 | Dave solo | Dave Side Projects | 3714 | 86 |
6 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 6 | 1154 |
6 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 7760 | 41 |
10 | 1 | 7/1/2016 12:00:00 AM | 453065416 | DMB | DMB | 11 | 2154 |
10 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 7394 | 31 |
10 | 3 | 9/19/2015 12:00:00 AM | 453063381 | Dave & Tim | Dave Side Projects | 297 | 127 |
10 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 4259 | 79 |
10 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 7634 | 41 |
18 | 1 | 7/9/2016 12:00:00 AM | 453065419 | DMB | DMB | 3 | 2154 |
18 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 8470 | 53 |
18 | 3 | 1/17/2015 12:00:00 AM | 453058208 | Dave & Tim | Dave Side Projects | 542 | 127 |
19 | 1 | 7/8/2016 12:00:00 AM | 453065418 | DMB | DMB | 4 | 2154 |
19 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 7394 | 31 |
19 | 3 | 1/17/2015 12:00:00 AM | 453058208 | Dave & Tim | Dave Side Projects | 542 | 127 |
19 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 3811 | 86 |
19 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 7379 | 31 |
20 | 1 | 7/9/2016 12:00:00 AM | 453065419 | DMB | DMB | 3 | 2154 |
20 | 2 | 5/15/2006 12:00:00 AM | 453056320 | Dave solo | Dave Side Projects | 3711 | 86 |
20 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 6 | 1154 |
20 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 3811 | 86 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 7880 | 52 |
20 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 7760 | 41 |
20 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 5056 | 32 |
55 | 1 | 7/9/2016 12:00:00 AM | 453065419 | DMB | DMB | 3 | 2154 |
55 | 2 | 9/2/2015 12:00:00 AM | 453064388 | Dave solo | Dave Side Projects | 314 | 127 |
55 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 6 | 1154 |
55 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 4259 | 79 |
55 | 1024 | 9/4/2014 12:00:00 AM | 453057206 | Dave, Tim & Rashawn | DMB | 677 | 122 |
75 | 1 | 7/8/2016 12:00:00 AM | 453065418 | DMB | DMB | 4 | 2154 |
75 | 2 | 2/17/2012 12:00:00 AM | 453056972 | Dave solo | Dave Side Projects | 1607 | 116 |
75 | 3 | 1/17/2015 12:00:00 AM | 453058208 | Dave & Tim | Dave Side Projects | 542 | 127 |
77 | 1 | 6/28/2016 12:00:00 AM | 453065414 | DMB | DMB | 14 | 2154 |
77 | 2 | 11/13/2001 12:00:00 AM | 62 | Dave solo | Dave Side Projects | 5355 | 1 |
77 | 3 | 1/16/2015 12:00:00 AM | 453058207 | Dave & Tim | Dave Side Projects | 543 | 127 |
80 | 1 | 7/8/2016 12:00:00 AM | 453065418 | DMB | DMB | 4 | 2154 |
80 | 2 | 9/2/2015 12:00:00 AM | 453064388 | Dave solo | Dave Side Projects | 314 | 127 |
80 | 3 | 9/19/2015 12:00:00 AM | 453063381 | Dave & Tim | Dave Side Projects | 297 | 127 |
236 | 1 | 7/2/2016 12:00:00 AM | 453065417 | DMB | DMB | 10 | 2154 |
236 | 2 | 9/24/2011 12:00:00 AM | 453056962 | Dave solo | Dave Side Projects | 1753 | 114 |
236 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 6 | 1154 |
236 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 3811 | 86 |
279 | 1 | 7/8/2016 12:00:00 AM | 453065418 | DMB | DMB | 4 | 2154 |
586 | 2 | 9/2/2015 12:00:00 AM | 453064388 | Dave solo | Dave Side Projects | 314 | 127 |
586 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 6 | 1154 |
605 | 12 | 7/3/1993 12:00:00 AM | 453089752 | C-ville Allstars | Carter Side Projects | 8410 | 53 |
732 | 1 | 6/21/2016 12:00:00 AM | 453065410 | DMB | DMB | 21 | 2154 |
2833 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 6 | 1154 |
4874 | 1 | 7/9/2016 12:00:00 AM | 453065419 | DMB | DMB | 3 | 2154 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
5 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 9252 | 65 |
5 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 8837 | 57 |
5 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 8482 | 53 |
5 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 3811 | 86 |
6 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 9082 | 65 |
6 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 8705 | 57 |
6 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 8482 | 53 |
6 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 8215 | 63 |
10 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 9082 | 65 |
10 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 7394 | 31 |
10 | 3 | 8/25/1994 12:00:00 AM | 453055361 | Dave & Tim | Dave Side Projects | 7992 | 52 |
10 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 4259 | 79 |
10 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 7634 | 41 |
18 | 1 | 9/20/1991 12:00:00 AM | 453056809 | DMB | DMB | 9062 | 65 |
18 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 8837 | 57 |
18 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 8482 | 53 |
19 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 9082 | 65 |
19 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 7394 | 31 |
19 | 3 | 9/26/1994 12:00:00 AM | 453055276 | Dave & Tim | Dave Side Projects | 7960 | 52 |
19 | 4 | 10/29/2005 12:00:00 AM | 453056234 | Dave & Friends | Dave Side Projects | 3909 | 84 |
19 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 7880 | 52 |
20 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 9082 | 65 |
20 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 8837 | 57 |
20 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 8482 | 53 |
20 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 4596 | 76 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 7880 | 52 |
20 | 15 | 3/10/1994 12:00:00 AM | 453089625 | Dave & Boyd | DMB | 8160 | 52 |
20 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 5056 | 32 |
55 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 6660 | 23 |
55 | 2 | 9/29/2001 12:00:00 AM | 55 | Dave solo | Dave Side Projects | 5400 | 1 |
55 | 3 | 1/20/1999 12:00:00 AM | 453054574 | Dave & Tim | Dave Side Projects | 6383 | 16 |
55 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 4596 | 76 |
55 | 1024 | 9/4/2014 12:00:00 AM | 453057206 | Dave, Tim & Rashawn | DMB | 677 | 122 |
75 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 5867 | 13 |
75 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 3713 | 86 |
75 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 4864 | 70 |
77 | 1 | 4/21/2001 12:00:00 AM | 2 | DMB | DMB | 5561 | 2 |
77 | 2 | 5/26/2001 12:00:00 AM | 453055807 | Dave solo | Dave Side Projects | 5526 | 1 |
77 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 4864 | 70 |
80 | 1 | 2/24/2001 12:00:00 AM | 453055934 | DMB | DMB | 5617 | 1 |
80 | 2 | 2/23/2001 12:00:00 AM | 453055792 | Dave solo | Dave Side Projects | 5618 | 33 |
80 | 3 | 7/15/2012 12:00:00 AM | 453057034 | Dave & Tim | Dave Side Projects | 1458 | 116 |
236 | 1 | 6/1/2013 12:00:00 AM | 453057090 | DMB | DMB | 1137 | 120 |
236 | 2 | 1/9/2004 12:00:00 AM | 453056065 | Dave solo | Dave Side Projects | 4568 | 79 |
236 | 3 | 10/28/2005 12:00:00 AM | 453056235 | Dave & Tim | Dave Side Projects | 3910 | 84 |
236 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 4596 | 76 |
279 | 1 | 6/17/2004 12:00:00 AM | 453056075 | DMB | DMB | 4408 | 80 |
301 | 1 | 5/9/2005 12:00:00 AM | 453056223 | DMB | DMB | 4082 | 84 |
370 | 1 | 6/2/2006 12:00:00 AM | 453056268 | DMB | DMB | 3693 | 87 |
583 | 1 | 4/14/2009 12:00:00 AM | 453056612 | DMB | DMB | 2646 | 103 |
586 | 1 | 6/6/2009 12:00:00 AM | 453056644 | DMB | DMB | 2593 | 106 |
586 | 2 | 11/13/2009 12:00:00 AM | 453056750 | Dave solo | Dave Side Projects | 2433 | 104 |
586 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | Dave Side Projects | 2563 | 104 |
605 | 12 | 7/3/1993 12:00:00 AM | 453089752 | C-ville Allstars | Carter Side Projects | 8410 | 53 |
732 | 1 | 9/8/2012 12:00:00 AM | 453057012 | DMB | DMB | 1403 | 117 |
2833 | 1 | 6/12/2015 12:00:00 AM | 453060220 | DMB | DMB | 396 | 128 |
2833 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 6 | 1154 |
4874 | 1 | 5/7/2016 12:00:00 AM | 453067393 | DMB | DMB | 66 | 2154 |