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 = 453056977 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 < '5/23/2012' OR (SongInfo.ShowDate = '5/23/2012' AND SongInfo.ShowID < 453056977)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 407.2991
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
6 | 1 | 9/16/2011 12:00:00 AM | 453056954 | DMB | DMB | 250 | 115 |
6 | 2 | 5/12/2006 12:00:00 AM | 453056318 | Dave solo | Dave Side Projects | 2203 | 86 |
6 | 3 | 12/11/2010 12:00:00 AM | 453056859 | Dave & Tim | Dave Side Projects | 529 | 113 |
6 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 6249 | 41 |
11 | 1 | 9/18/2011 12:00:00 AM | 453056956 | DMB | DMB | 248 | 115 |
11 | 2 | 7/28/2011 12:00:00 AM | 453056947 | Dave solo | Dave Side Projects | 300 | 114 |
11 | 3 | 12/6/2010 12:00:00 AM | 453056862 | Dave & Tim | Dave Side Projects | 534 | 113 |
11 | 4 | 12/17/2003 12:00:00 AM | 453056049 | Dave & Friends | Dave Side Projects | 3080 | 76 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 6704 | 63 |
20 | 1 | 5/19/2012 12:00:00 AM | 453056975 | DMB | DMB | 4 | 117 |
20 | 2 | 5/15/2006 12:00:00 AM | 453056320 | Dave solo | Dave Side Projects | 2200 | 86 |
20 | 3 | 11/19/2011 12:00:00 AM | 453056966 | Dave & Tim | Dave Side Projects | 186 | 114 |
20 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 2300 | 86 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 6369 | 52 |
20 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 6249 | 41 |
20 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 3545 | 32 |
21 | 1 | 9/17/2011 12:00:00 AM | 453056955 | DMB | DMB | 249 | 115 |
21 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 2202 | 86 |
21 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 3306 | 75 |
41 | 1 | 5/22/2012 12:00:00 AM | 453056976 | DMB | DMB | 1 | 117 |
41 | 2 | 3/11/2012 12:00:00 AM | 453057014 | Dave solo | Dave Side Projects | 73 | 116 |
41 | 3 | 11/19/2011 12:00:00 AM | 453056966 | Dave & Tim | Dave Side Projects | 186 | 114 |
41 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 2300 | 86 |
41 | 8 | 3/13/2011 12:00:00 AM | 453056925 | Secret Stash | Stefan Side Projects | 437 | 114 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 5868 | 31 |
44 | 1 | 9/18/2011 12:00:00 AM | 453056956 | DMB | DMB | 248 | 115 |
44 | 3 | 10/26/2008 12:00:00 AM | 453056610 | Dave & Tim | Dave Side Projects | 1305 | 97 |
47 | 1 | 5/19/2012 12:00:00 AM | 453056975 | DMB | DMB | 4 | 117 |
47 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 2202 | 86 |
47 | 3 | 10/28/2005 12:00:00 AM | 453056235 | Dave & Tim | Dave Side Projects | 2399 | 84 |
47 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 2300 | 86 |
47 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 5868 | 31 |
55 | 1 | 5/18/2012 12:00:00 AM | 453056974 | DMB | DMB | 5 | 117 |
55 | 2 | 3/11/2012 12:00:00 AM | 453057014 | Dave solo | Dave Side Projects | 73 | 116 |
55 | 3 | 11/19/2011 12:00:00 AM | 453056966 | Dave & Tim | Dave Side Projects | 186 | 114 |
55 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 2748 | 79 |
65 | 1 | 9/17/2011 12:00:00 AM | 453056955 | DMB | DMB | 249 | 115 |
65 | 2 | 4/13/2011 12:00:00 AM | 453056930 | Dave solo | Dave Side Projects | 406 | 114 |
65 | 3 | 11/19/2011 12:00:00 AM | 453056966 | Dave & Tim | Dave Side Projects | 186 | 114 |
65 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 2300 | 86 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | Dave Side Projects | 4476 | 15 |
74 | 1 | 5/20/2012 12:00:00 AM | 453056973 | DMB | DMB | 3 | 117 |
74 | 3 | 3/31/2003 12:00:00 AM | 453055958 | Dave & Tim | Dave Side Projects | 3341 | 70 |
75 | 1 | 5/18/2012 12:00:00 AM | 453056974 | DMB | DMB | 5 | 117 |
75 | 2 | 2/17/2012 12:00:00 AM | 453056972 | Dave solo | Dave Side Projects | 96 | 116 |
75 | 3 | 11/18/2011 12:00:00 AM | 453056965 | Dave & Tim | Dave Side Projects | 187 | 114 |
92 | 1 | 9/17/2011 12:00:00 AM | 453056955 | DMB | DMB | 249 | 115 |
376 | 3 | 2/27/2007 12:00:00 AM | 453056401 | Dave & Tim | Dave Side Projects | 1912 | 91 |
440 | 1 | 9/18/2011 12:00:00 AM | 453056956 | DMB | DMB | 248 | 115 |
440 | 3 | 11/18/2011 12:00:00 AM | 453056965 | Dave & Tim | Dave Side Projects | 187 | 114 |
578 | 1 | 9/2/2011 12:00:00 AM | 453056936 | DMB | DMB | 264 | 115 |
578 | 3 | 12/10/2009 12:00:00 AM | 453056729 | Dave & Tim | Dave Side Projects | 895 | 104 |
583 | 1 | 5/20/2012 12:00:00 AM | 453056973 | DMB | DMB | 3 | 117 |
723 | 2 | 5/10/2012 12:00:00 AM | 453057016 | Dave solo | Dave Side Projects | 13 | 116 |
725 | 1 | 5/22/2012 12:00:00 AM | 453056976 | DMB | DMB | 1 | 117 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
6 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 7571 | 65 |
6 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 7194 | 57 |
6 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 6971 | 53 |
6 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 6704 | 63 |
11 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 7571 | 65 |
11 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 7194 | 57 |
11 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 6971 | 53 |
11 | 4 | 12/15/2003 12:00:00 AM | 453056047 | Dave & Friends | Dave Side Projects | 3082 | 76 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 6704 | 63 |
20 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 7571 | 65 |
20 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 7326 | 57 |
20 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 6971 | 53 |
20 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 3085 | 76 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 6369 | 52 |
20 | 15 | 3/10/1994 12:00:00 AM | 453089625 | Dave & Boyd | DMB | 6649 | 52 |
20 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 3545 | 32 |
21 | 1 | 2/13/1992 12:00:00 AM | 453055738 | DMB | DMB | 7405 | 56 |
21 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 7194 | 57 |
21 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 6971 | 53 |
41 | 1 | 4/7/1995 12:00:00 AM | 453055187 | DMB | DMB | 6256 | 37 |
41 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 5883 | 31 |
41 | 3 | 2/1/1996 12:00:00 AM | 453054992 | Dave & Tim | Dave Side Projects | 5956 | 27 |
41 | 4 | 12/20/2003 12:00:00 AM | 453056051 | Dave & Friends | Dave Side Projects | 3077 | 76 |
41 | 8 | 3/13/2011 12:00:00 AM | 453056925 | Secret Stash | Stefan Side Projects | 437 | 114 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 5868 | 31 |
44 | 1 | 12/16/1994 12:00:00 AM | 453056378 | DMB | DMB | 6368 | 45 |
44 | 3 | 2/8/1996 12:00:00 AM | 453054997 | Dave & Tim | Dave Side Projects | 5949 | 27 |
47 | 1 | 10/4/1995 12:00:00 AM | 453055261 | DMB | DMB | 6076 | 41 |
47 | 2 | 3/8/1999 12:00:00 AM | 453054607 | Dave solo | Dave Side Projects | 4825 | 62 |
47 | 3 | 12/16/1996 12:00:00 AM | 453055128 | Dave & Tim | Dave Side Projects | 5637 | 31 |
47 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 3084 | 76 |
47 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 5868 | 31 |
55 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 5149 | 23 |
55 | 2 | 9/29/2001 12:00:00 AM | 55 | Dave solo | Dave Side Projects | 3889 | 1 |
55 | 3 | 1/20/1999 12:00:00 AM | 453054574 | Dave & Tim | Dave Side Projects | 4872 | 16 |
55 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 3085 | 76 |
65 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 4356 | 13 |
65 | 2 | 3/8/1999 12:00:00 AM | 453056428 | Dave solo | Dave Side Projects | 4825 | 62 |
65 | 3 | 1/29/1999 12:00:00 AM | 453054581 | Dave & Tim | Dave Side Projects | 4863 | 16 |
65 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 3085 | 76 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | Dave Side Projects | 4476 | 15 |
74 | 1 | 5/14/2001 12:00:00 AM | 13 | DMB | DMB | 4027 | 2 |
74 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 3353 | 70 |
75 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 4356 | 13 |
75 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 2202 | 86 |
75 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 3353 | 70 |
92 | 1 | 10/3/1996 12:00:00 AM | 453055078 | DMB | DMB | 5711 | 29 |
376 | 1 | 6/23/2006 12:00:00 AM | 453056280 | DMB | DMB | 2161 | 87 |
376 | 3 | 2/24/2007 12:00:00 AM | 453056399 | Dave & Tim | Dave Side Projects | 1915 | 91 |
440 | 1 | 8/1/2007 12:00:00 AM | 453056468 | DMB | DMB | 1757 | 96 |
440 | 3 | 2/23/2007 12:00:00 AM | 453056398 | Dave & Tim | Dave Side Projects | 1916 | 91 |
578 | 1 | 5/27/2009 12:00:00 AM | 453056640 | DMB | DMB | 1092 | 106 |
578 | 3 | 12/10/2009 12:00:00 AM | 453056729 | Dave & Tim | Dave Side Projects | 895 | 104 |
583 | 1 | 4/14/2009 12:00:00 AM | 453056612 | DMB | DMB | 1135 | 103 |
648 | 1 | 7/28/2010 12:00:00 AM | 453056789 | DMB | DMB | 665 | 110 |
723 | 1 | 5/18/2012 12:00:00 AM | 453056974 | DMB | DMB | 5 | 117 |
723 | 2 | 4/24/2012 12:00:00 AM | 453057017 | Dave solo | Dave Side Projects | 29 | 116 |
725 | 1 | 5/18/2012 12:00:00 AM | 453056974 | DMB | DMB | 5 | 117 |