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 = 453056653 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/7/2009' OR (SongInfo.ShowDate = '8/7/2009' AND SongInfo.ShowID < 453056653)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 340.6738
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
13 | 1 | 8/5/2009 12:00:00 AM | 453056659 | DMB | DMB | 2 | 106 |
13 | 2 | 6/11/1999 12:00:00 AM | 453055897 | Dave solo | Dave Side Projects | 3710 | 62 |
13 | 3 | 10/26/2008 12:00:00 AM | 453056610 | Dave & Tim | Dave Side Projects | 285 | 97 |
13 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 1280 | 86 |
13 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 4848 | 31 |
19 | 1 | 8/4/2009 12:00:00 AM | 453056658 | DMB | DMB | 3 | 106 |
19 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 4863 | 31 |
19 | 3 | 4/21/2007 12:00:00 AM | 453056465 | Dave & Tim | Dave Side Projects | 839 | 93 |
19 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 1280 | 86 |
19 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 4848 | 31 |
22 | 1 | 8/4/2009 12:00:00 AM | 453056658 | DMB | DMB | 3 | 106 |
22 | 2 | 5/15/2006 12:00:00 AM | 453056320 | Dave solo | Dave Side Projects | 1180 | 86 |
22 | 3 | 5/20/2008 12:00:00 AM | 453056597 | Dave & Tim | Dave Side Projects | 444 | 97 |
22 | 4 | 1/16/2004 12:00:00 AM | 453056056 | Dave & Friends | Dave Side Projects | 2030 | 77 |
22 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 5964 | 53 |
22 | 15 | 10/29/1994 12:00:00 AM | 453089864 | Dave & Boyd | DMB | 5396 | 63 |
46 | 1 | 8/4/2009 12:00:00 AM | 453056658 | DMB | DMB | 3 | 106 |
46 | 2 | 5/15/2006 12:00:00 AM | 453056320 | Dave solo | Dave Side Projects | 1180 | 86 |
46 | 3 | 10/26/2008 12:00:00 AM | 453056610 | Dave & Tim | Dave Side Projects | 285 | 97 |
46 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 4848 | 31 |
46 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 5103 | 41 |
55 | 1 | 8/4/2009 12:00:00 AM | 453056658 | DMB | DMB | 3 | 106 |
55 | 2 | 12/16/2006 12:00:00 AM | 453056410 | Dave solo | Dave Side Projects | 965 | 86 |
55 | 3 | 10/26/2008 12:00:00 AM | 453056610 | Dave & Tim | Dave Side Projects | 285 | 97 |
55 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 1728 | 79 |
75 | 1 | 8/4/2009 12:00:00 AM | 453056658 | DMB | DMB | 3 | 106 |
75 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 1182 | 86 |
75 | 3 | 3/13/2007 12:00:00 AM | 453056409 | Dave & Tim | Dave Side Projects | 878 | 91 |
205 | 1 | 7/22/2009 12:00:00 AM | 453056638 | DMB | DMB | 16 | 106 |
205 | 2 | 12/21/2007 12:00:00 AM | 453056524 | Dave solo | Dave Side Projects | 595 | 93 |
205 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | Dave Side Projects | 32 | 104 |
205 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 1280 | 86 |
205 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 2525 | 32 |
205 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | Dave Side Projects | 2100 | 75 |
242 | 1 | 8/4/2009 12:00:00 AM | 453056658 | DMB | DMB | 3 | 106 |
242 | 4 | 6/11/2004 12:00:00 AM | 453056073 | Dave & Friends | Dave Side Projects | 1883 | 79 |
301 | 1 | 8/5/2009 12:00:00 AM | 453056659 | DMB | DMB | 2 | 106 |
571 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | Dave Side Projects | 32 | 104 |
574 | 1 | 8/5/2009 12:00:00 AM | 453056659 | DMB | DMB | 2 | 106 |
579 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | Dave Side Projects | 32 | 104 |
580 | 1 | 8/5/2009 12:00:00 AM | 453056659 | DMB | DMB | 2 | 106 |
586 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | Dave Side Projects | 32 | 104 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
13 | 1 | 4/5/1992 12:00:00 AM | 453055729 | DMB | DMB | 6333 | 56 |
13 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 6174 | 57 |
13 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 5951 | 53 |
13 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 1728 | 79 |
13 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 5349 | 52 |
19 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 6551 | 65 |
19 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 4863 | 31 |
19 | 3 | 9/26/1994 12:00:00 AM | 453055276 | Dave & Tim | Dave Side Projects | 5429 | 52 |
19 | 4 | 10/29/2005 12:00:00 AM | 453056234 | Dave & Friends | Dave Side Projects | 1378 | 84 |
19 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 5349 | 52 |
22 | 1 | 3/1/1992 12:00:00 AM | 453055741 | DMB | DMB | 6368 | 56 |
22 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 6174 | 57 |
22 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 5951 | 53 |
22 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 2065 | 76 |
22 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 5964 | 53 |
22 | 15 | 3/10/1994 12:00:00 AM | 453089625 | Dave & Boyd | DMB | 5629 | 52 |
46 | 1 | 10/4/1995 12:00:00 AM | 453055261 | DMB | DMB | 5056 | 41 |
46 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 4863 | 31 |
46 | 3 | 9/24/1995 12:00:00 AM | 453055259 | Dave & Tim | Dave Side Projects | 5066 | 41 |
46 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 4848 | 31 |
46 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 5103 | 41 |
55 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 4129 | 23 |
55 | 2 | 9/29/2001 12:00:00 AM | 55 | Dave solo | Dave Side Projects | 2869 | 1 |
55 | 3 | 1/20/1999 12:00:00 AM | 453054574 | Dave & Tim | Dave Side Projects | 3852 | 16 |
55 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 2065 | 76 |
75 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 3336 | 13 |
75 | 2 | 5/13/2006 12:00:00 AM | 453056319 | Dave solo | Dave Side Projects | 1182 | 86 |
75 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 2333 | 70 |
205 | 1 | 5/28/2002 12:00:00 AM | 453055851 | DMB | DMB | 2628 | 12 |
205 | 2 | 7/12/2002 12:00:00 AM | 453055902 | Dave solo | Dave Side Projects | 2583 | 66 |
205 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 2333 | 70 |
205 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 2065 | 76 |
205 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 2525 | 32 |
205 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | Dave Side Projects | 2100 | 75 |
242 | 1 | 8/4/2009 12:00:00 AM | 453056658 | DMB | DMB | 3 | 106 |
242 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 2065 | 76 |
301 | 1 | 5/9/2005 12:00:00 AM | 453056223 | DMB | DMB | 1551 | 84 |
373 | 1 | 6/10/2006 12:00:00 AM | 453056273 | DMB | DMB | 1154 | 87 |
571 | 1 | 6/6/2009 12:00:00 AM | 453056644 | DMB | DMB | 62 | 106 |
571 | 3 | 6/25/2009 12:00:00 AM | 453056713 | Dave & Tim | Dave Side Projects | 43 | 104 |
574 | 1 | 6/12/2009 12:00:00 AM | 453056651 | DMB | DMB | 56 | 106 |
577 | 1 | 5/29/2009 12:00:00 AM | 453056641 | DMB | DMB | 70 | 106 |
579 | 1 | 4/14/2009 12:00:00 AM | 453056612 | DMB | DMB | 115 | 103 |
579 | 3 | 6/25/2009 12:00:00 AM | 453056713 | Dave & Tim | Dave Side Projects | 43 | 104 |
580 | 1 | 5/30/2009 12:00:00 AM | 453056642 | DMB | DMB | 69 | 106 |
583 | 1 | 4/14/2009 12:00:00 AM | 453056612 | DMB | DMB | 115 | 103 |
584 | 1 | 5/5/2009 12:00:00 AM | 453056624 | DMB | DMB | 94 | 103 |
586 | 1 | 6/6/2009 12:00:00 AM | 453056644 | DMB | DMB | 62 | 106 |
586 | 3 | 7/6/2009 12:00:00 AM | 453056712 | Dave & Tim | Dave Side Projects | 32 | 104 |