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 = 453056193 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/6/2005' OR (SongInfo.ShowDate = '7/6/2005' AND SongInfo.ShowID < 453056193)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 376.3945
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
10 | 1 | 6/28/2005 12:00:00 AM | 453056188 | DMB | DMB | 8 | 83 |
10 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 3370 | 31 |
10 | 3 | 2/6/1999 12:00:00 AM | 453054586 | Dave & Tim | Dave Side Projects | 2342 | 16 |
10 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 235 | 79 |
10 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 3610 | 41 |
12 | 1 | 7/1/2005 12:00:00 AM | 453056190 | DMB | DMB | 5 | 83 |
12 | 2 | 11/20/2002 12:00:00 AM | 453055947 | Dave solo | Dave Side Projects | 959 | 32 |
12 | 3 | 3/29/2003 12:00:00 AM | 453055957 | Dave & Tim | Dave Side Projects | 830 | 70 |
13 | 1 | 7/2/2005 12:00:00 AM | 453056191 | DMB | DMB | 4 | 83 |
13 | 2 | 6/11/1999 12:00:00 AM | 453055897 | Dave solo | Dave Side Projects | 2217 | 62 |
13 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 793 | 75 |
13 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 235 | 79 |
13 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 3355 | 31 |
20 | 1 | 7/1/2005 12:00:00 AM | 453056190 | DMB | DMB | 5 | 83 |
20 | 2 | 12/11/2002 12:00:00 AM | 453055946 | Dave solo | Dave Side Projects | 938 | 32 |
20 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 793 | 75 |
20 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 235 | 79 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 3856 | 52 |
20 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 3736 | 41 |
20 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 1032 | 32 |
21 | 1 | 6/8/2005 12:00:00 AM | 453056178 | DMB | DMB | 28 | 83 |
21 | 2 | 3/16/2002 12:00:00 AM | 453055784 | Dave solo | Dave Side Projects | 1208 | 32 |
21 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 793 | 75 |
33 | 1 | 7/2/2005 12:00:00 AM | 453056191 | DMB | DMB | 4 | 83 |
33 | 3 | 2/21/1997 12:00:00 AM | 453054953 | Dave & Tim | Dave Side Projects | 3057 | 24 |
33 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 3736 | 41 |
61 | 1 | 8/7/2003 12:00:00 AM | 453055998 | DMB | DMB | 699 | 72 |
65 | 2 | 1/9/2004 12:00:00 AM | 453056065 | Dave solo | Dave Side Projects | 544 | 79 |
65 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 793 | 75 |
65 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 235 | 79 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | Dave Side Projects | 1963 | 15 |
96 | 1 | 6/29/2005 12:00:00 AM | 453056189 | DMB | DMB | 7 | 83 |
96 | 2 | 10/24/2002 12:00:00 AM | 453055916 | Dave solo | Dave Side Projects | 986 | 32 |
96 | 3 | 3/28/2003 12:00:00 AM | 453055956 | Dave & Tim | Dave Side Projects | 831 | 70 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 4471 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | Openers and Collaborators | 4534 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 4094 | 1133 |
96 | 45 | 4/30/2005 12:00:00 AM | 453086573 | Gov't Mule | Openers and Collaborators | 67 | 1144 |
96 | 63 | 6/30/2004 12:00:00 AM | 453063318 | Keller Williams | Openers and Collaborators | 371 | 1143 |
127 | 1 | 6/13/2005 12:00:00 AM | 453056180 | DMB | DMB | 23 | 83 |
127 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 4681 | 57 |
127 | 3 | 4/4/2003 12:00:00 AM | 453055960 | Dave & Tim | Dave Side Projects | 824 | 70 |
127 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 571 | 76 |
127 | 12 | 1/12/1993 12:00:00 AM | 453055495 | C-ville Allstars | Carter Side Projects | 4558 | 53 |
127 | 20 | 5/6/2001 12:00:00 AM | 453056944 | Jazzfest Superjam | Carter Side Projects | 1522 | 1 |
127 | 26 | 1/16/1994 12:00:00 AM | 453063247 | The Samples | Openers and Collaborators | 4189 | 1133 |
127 | 31 | 10/15/1994 12:00:00 AM | 453063256 | Phish | Openers and Collaborators | 3917 | 1133 |
127 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 3610 | 41 |
287 | 1 | 7/5/2005 12:00:00 AM | 453056192 | DMB | DMB | 1 | 83 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
10 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 5058 | 65 |
10 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 3370 | 31 |
10 | 3 | 8/25/1994 12:00:00 AM | 453055361 | Dave & Tim | Dave Side Projects | 3968 | 52 |
10 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 235 | 79 |
10 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 3610 | 41 |
12 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 5058 | 65 |
12 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 4681 | 57 |
12 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 4458 | 53 |
13 | 1 | 4/5/1992 12:00:00 AM | 453055729 | DMB | DMB | 4840 | 56 |
13 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 4681 | 57 |
13 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 4458 | 53 |
13 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | Dave Side Projects | 235 | 79 |
13 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 3856 | 52 |
20 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 5058 | 65 |
20 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 4813 | 57 |
20 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 4458 | 53 |
20 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 572 | 76 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 3856 | 52 |
20 | 15 | 3/10/1994 12:00:00 AM | 453089625 | Dave & Boyd | DMB | 4136 | 52 |
20 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 1032 | 32 |
21 | 1 | 2/13/1992 12:00:00 AM | 453055738 | DMB | DMB | 4892 | 56 |
21 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 4681 | 57 |
21 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 4458 | 53 |
33 | 1 | 1/19/1993 12:00:00 AM | 453055496 | DMB | DMB | 4551 | 51 |
33 | 3 | 5/4/1994 12:00:00 AM | 453055404 | Dave & Tim | Dave Side Projects | 4081 | 52 |
33 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 3736 | 41 |
61 | 1 | 5/25/1998 12:00:00 AM | 453054700 | DMB | DMB | 2599 | 19 |
65 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 1843 | 13 |
65 | 2 | 3/8/1999 12:00:00 AM | 453056428 | Dave solo | Dave Side Projects | 2312 | 62 |
65 | 3 | 1/29/1999 12:00:00 AM | 453054581 | Dave & Tim | Dave Side Projects | 2350 | 16 |
65 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 572 | 76 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | Dave Side Projects | 1963 | 15 |
96 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 5058 | 65 |
96 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 4813 | 57 |
96 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 4458 | 53 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 4471 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | Openers and Collaborators | 4534 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 4094 | 1133 |
96 | 45 | 4/30/2005 12:00:00 AM | 453086573 | Gov't Mule | Openers and Collaborators | 67 | 1144 |
96 | 63 | 6/30/2004 12:00:00 AM | 453063318 | Keller Williams | Openers and Collaborators | 371 | 1143 |
127 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 5058 | 65 |
127 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 4681 | 57 |
127 | 3 | 5/4/1994 12:00:00 AM | 453055404 | Dave & Tim | Dave Side Projects | 4081 | 52 |
127 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 571 | 76 |
127 | 12 | 1/6/1993 12:00:00 AM | 453056967 | C-ville Allstars | Carter Side Projects | 4564 | 53 |
127 | 20 | 5/6/2001 12:00:00 AM | 453056944 | Jazzfest Superjam | Carter Side Projects | 1522 | 1 |
127 | 26 | 1/15/1994 12:00:00 AM | 453063246 | The Samples | Openers and Collaborators | 4190 | 1133 |
127 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 4094 | 1133 |
127 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 3610 | 41 |
287 | 1 | 3/20/2005 12:00:00 AM | 453056171 | DMB | DMB | 108 | 82 |
288 | 1 | 4/30/2005 12:00:00 AM | 453056213 | DMB | DMB | 67 | 84 |
289 | 1 | 6/2/2005 12:00:00 AM | 453056174 | DMB | DMB | 34 | 83 |
290 | 1 | 5/9/2005 12:00:00 AM | 453056223 | DMB | DMB | 58 | 84 |
292 | 1 | 5/9/2005 12:00:00 AM | 453056223 | DMB | DMB | 58 | 84 |
295 | 1 | 4/30/2005 12:00:00 AM | 453056213 | DMB | DMB | 67 | 84 |
296 | 1 | 5/9/2005 12:00:00 AM | 453056223 | DMB | DMB | 58 | 84 |
299 | 1 | 6/4/2005 12:00:00 AM | 453056175 | DMB | DMB | 32 | 83 |
300 | 1 | 6/8/2005 12:00:00 AM | 453056178 | DMB | DMB | 28 | 83 |