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 = 453056009 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 < '9/6/2003' OR (SongInfo.ShowDate = '9/6/2003' AND SongInfo.ShowID < 453056009)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 333.1873
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
6 | 1 | 9/2/2003 12:00:00 AM | 453056006 | DMB | DMB | 4 | 72 |
6 | 2 | 11/13/2001 12:00:00 AM | 62 | Dave solo | Dave Side Projects | 662 | 1 |
6 | 3 | 4/4/2003 12:00:00 AM | 453055960 | Dave & Tim | Dave Side Projects | 155 | 70 |
6 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 3067 | 41 |
11 | 1 | 8/30/2003 12:00:00 AM | 453056004 | DMB | DMB | 7 | 72 |
11 | 2 | 11/12/2001 12:00:00 AM | 61 | Dave solo | Dave Side Projects | 663 | 1 |
11 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 124 | 75 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 3522 | 63 |
17 | 1 | 9/3/2003 12:00:00 AM | 453056007 | DMB | DMB | 3 | 72 |
17 | 2 | 12/20/2002 12:00:00 AM | 453055944 | Dave solo | Dave Side Projects | 260 | 32 |
17 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 124 | 75 |
20 | 1 | 7/27/2003 12:00:00 AM | 453055991 | DMB | DMB | 41 | 72 |
20 | 2 | 12/11/2002 12:00:00 AM | 453055946 | Dave solo | Dave Side Projects | 269 | 32 |
20 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 124 | 75 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 3187 | 52 |
20 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 3067 | 41 |
20 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 363 | 32 |
24 | 1 | 9/3/2003 12:00:00 AM | 453056007 | DMB | DMB | 3 | 72 |
24 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 4012 | 57 |
24 | 3 | 4/1/2003 12:00:00 AM | 453055959 | Dave & Tim | Dave Side Projects | 158 | 70 |
49 | 1 | 9/2/2003 12:00:00 AM | 453056006 | DMB | DMB | 4 | 72 |
49 | 2 | 5/26/2001 12:00:00 AM | 453055807 | Dave solo | Dave Side Projects | 833 | 1 |
49 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 124 | 75 |
54 | 1 | 9/3/2003 12:00:00 AM | 453056007 | DMB | DMB | 3 | 72 |
54 | 2 | 12/1/1998 12:00:00 AM | 453055906 | Dave solo | Dave Side Projects | 1740 | 34 |
54 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | Dave Side Projects | 1626 | 16 |
55 | 1 | 9/2/2003 12:00:00 AM | 453056006 | DMB | DMB | 4 | 72 |
55 | 2 | 11/7/2002 12:00:00 AM | 453055941 | Dave solo | Dave Side Projects | 303 | 32 |
55 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 124 | 75 |
58 | 1 | 9/3/2003 12:00:00 AM | 453056007 | DMB | DMB | 3 | 72 |
58 | 2 | 8/6/2003 12:00:00 AM | 453056038 | Dave solo | Dave Side Projects | 31 | 75 |
58 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 124 | 75 |
59 | 1 | 9/3/2003 12:00:00 AM | 453056007 | DMB | DMB | 3 | 72 |
59 | 2 | 10/24/2002 12:00:00 AM | 453055916 | Dave solo | Dave Side Projects | 317 | 32 |
59 | 3 | 3/13/1999 12:00:00 AM | 453054612 | Dave & Tim | Dave Side Projects | 1638 | 16 |
65 | 1 | 8/30/2003 12:00:00 AM | 453056004 | DMB | DMB | 7 | 72 |
65 | 2 | 8/6/2003 12:00:00 AM | 453056038 | Dave solo | Dave Side Projects | 31 | 75 |
65 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 124 | 75 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | Dave Side Projects | 1294 | 15 |
84 | 1 | 9/3/2003 12:00:00 AM | 453056007 | DMB | DMB | 3 | 72 |
86 | 2 | 10/24/2002 12:00:00 AM | 453055916 | Dave solo | Dave Side Projects | 317 | 32 |
86 | 3 | 3/25/2003 12:00:00 AM | 453055954 | Dave & Tim | Dave Side Projects | 165 | 70 |
90 | 1 | 9/3/2003 12:00:00 AM | 453056007 | DMB | DMB | 3 | 72 |
90 | 2 | 12/20/2002 12:00:00 AM | 453055944 | Dave solo | Dave Side Projects | 260 | 32 |
90 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 124 | 75 |
96 | 1 | 9/3/2003 12:00:00 AM | 453056007 | DMB | DMB | 3 | 72 |
96 | 2 | 10/24/2002 12:00:00 AM | 453055916 | Dave solo | Dave Side Projects | 317 | 32 |
96 | 3 | 3/28/2003 12:00:00 AM | 453055956 | Dave & Tim | Dave Side Projects | 162 | 70 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 3802 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | Openers and Collaborators | 3865 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 3425 | 1133 |
121 | 1 | 9/3/2003 12:00:00 AM | 453056007 | DMB | DMB | 3 | 72 |
121 | 2 | 10/24/2002 12:00:00 AM | 453055916 | Dave solo | Dave Side Projects | 317 | 32 |
121 | 3 | 5/5/2003 12:00:00 AM | 453056019 | Dave & Tim | Dave Side Projects | 124 | 75 |
121 | 31 | 10/15/1994 12:00:00 AM | 453063256 | Phish | Openers and Collaborators | 3248 | 1133 |
121 | 50 | 5/2/2001 12:00:00 AM | 453063293 | Terrence Simien | Openers and Collaborators | 857 | 1140 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
6 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 4389 | 65 |
6 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 4012 | 57 |
6 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 3789 | 53 |
6 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 3522 | 63 |
11 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 4389 | 65 |
11 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 4012 | 57 |
11 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 3789 | 53 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 3522 | 63 |
17 | 1 | 10/22/1991 12:00:00 AM | 453055864 | DMB | DMB | 4337 | 65 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 4012 | 57 |
17 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 3789 | 53 |
20 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 4389 | 65 |
20 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 4144 | 57 |
20 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 3789 | 53 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 3187 | 52 |
20 | 15 | 3/10/1994 12:00:00 AM | 453089625 | Dave & Boyd | DMB | 3467 | 52 |
20 | 9127 | 9/8/2002 12:00:00 AM | 453055882 | Dave & Jason Mraz's Band | Dave Side Projects | 363 | 32 |
24 | 1 | 5/26/1992 12:00:00 AM | 453055649 | DMB | DMB | 4120 | 56 |
24 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 4012 | 57 |
24 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 3789 | 53 |
49 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 1967 | 23 |
49 | 2 | 7/1/1998 12:00:00 AM | 453056508 | Dave solo | Dave Side Projects | 1893 | 23 |
49 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 1691 | 16 |
54 | 1 | 8/13/1998 12:00:00 AM | 453054742 | DMB | DMB | 1850 | 21 |
54 | 2 | 5/4/1998 12:00:00 AM | 453055904 | Dave solo | Dave Side Projects | 1951 | 34 |
54 | 3 | 7/13/1997 12:00:00 AM | 453054985 | Dave & Tim | Dave Side Projects | 2246 | 26 |
55 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 1967 | 23 |
55 | 2 | 9/29/2001 12:00:00 AM | 55 | Dave solo | Dave Side Projects | 707 | 1 |
55 | 3 | 1/20/1999 12:00:00 AM | 453054574 | Dave & Tim | Dave Side Projects | 1690 | 16 |
58 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 1967 | 23 |
58 | 2 | 6/6/1998 12:00:00 AM | 453055901 | Dave solo | Dave Side Projects | 1918 | 34 |
58 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 1691 | 16 |
59 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 1967 | 23 |
59 | 2 | 10/24/2002 12:00:00 AM | 453055916 | Dave solo | Dave Side Projects | 317 | 32 |
59 | 3 | 1/26/1999 12:00:00 AM | 453054578 | Dave & Tim | Dave Side Projects | 1684 | 16 |
65 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 1174 | 13 |
65 | 2 | 3/8/1999 12:00:00 AM | 453056428 | Dave solo | Dave Side Projects | 1643 | 62 |
65 | 3 | 1/29/1999 12:00:00 AM | 453054581 | Dave & Tim | Dave Side Projects | 1681 | 16 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | Dave Side Projects | 1294 | 15 |
84 | 1 | 4/21/2001 12:00:00 AM | 2 | DMB | DMB | 868 | 2 |
86 | 1 | 5/26/2001 12:00:00 AM | 18 | DMB | DMB | 833 | 2 |
86 | 2 | 10/24/2002 12:00:00 AM | 453055916 | Dave solo | Dave Side Projects | 317 | 32 |
86 | 3 | 3/25/2003 12:00:00 AM | 453055954 | Dave & Tim | Dave Side Projects | 165 | 70 |
90 | 1 | 4/4/2002 12:00:00 AM | 453055751 | DMB | DMB | 520 | 12 |
90 | 2 | 10/14/2001 12:00:00 AM | 57 | Dave solo | Dave Side Projects | 692 | 1 |
90 | 3 | 3/19/2003 12:00:00 AM | 453055948 | Dave & Tim | Dave Side Projects | 171 | 70 |
96 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 4389 | 65 |
96 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 4144 | 57 |
96 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 3789 | 53 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 3802 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | Openers and Collaborators | 3865 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 3425 | 1133 |
121 | 1 | 11/26/1991 12:00:00 AM | 453056168 | DMB | DMB | 4302 | 65 |
121 | 2 | 10/14/2001 12:00:00 AM | 57 | Dave solo | Dave Side Projects | 692 | 1 |
121 | 3 | 2/10/1997 12:00:00 AM | 453054945 | Dave & Tim | Dave Side Projects | 2399 | 24 |
121 | 31 | 10/15/1994 12:00:00 AM | 453063256 | Phish | Openers and Collaborators | 3248 | 1133 |
121 | 50 | 5/1/2001 12:00:00 AM | 453063292 | Terrence Simien | Openers and Collaborators | 858 | 1140 |