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 = 453054747 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/21/1998' OR (SongInfo.ShowDate = '8/21/1998' AND SongInfo.ShowID < 453054747)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 331.6677
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
2 | 1 | 7/29/1998 12:00:00 AM | 453054732 | DMB | DMB | 23 | 21 |
2 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 859 | 31 |
2 | 3 | 7/13/1997 12:00:00 AM | 453054985 | Dave & Tim | Dave Side Projects | 404 | 26 |
5 | 1 | 8/20/1998 12:00:00 AM | 453054746 | DMB | DMB | 1 | 21 |
5 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 859 | 31 |
5 | 3 | 7/13/1997 12:00:00 AM | 453054985 | Dave & Tim | Dave Side Projects | 404 | 26 |
6 | 1 | 8/20/1998 12:00:00 AM | 453054746 | DMB | DMB | 1 | 21 |
6 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 859 | 31 |
6 | 3 | 7/13/1997 12:00:00 AM | 453054985 | Dave & Tim | Dave Side Projects | 404 | 26 |
6 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 1225 | 41 |
9 | 1 | 8/9/1998 12:00:00 AM | 453054740 | DMB | DMB | 12 | 21 |
9 | 2 | 1/24/1997 12:00:00 AM | 453055937 | Dave solo | Dave Side Projects | 574 | 26 |
9 | 3 | 7/13/1997 12:00:00 AM | 453054985 | Dave & Tim | Dave Side Projects | 404 | 26 |
12 | 1 | 8/15/1998 12:00:00 AM | 453054744 | DMB | DMB | 6 | 21 |
12 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 859 | 31 |
12 | 3 | 2/18/1997 12:00:00 AM | 453054951 | Dave & Tim | Dave Side Projects | 549 | 24 |
13 | 1 | 8/18/1998 12:00:00 AM | 453054745 | DMB | DMB | 3 | 21 |
13 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 859 | 31 |
13 | 3 | 7/13/1997 12:00:00 AM | 453054985 | Dave & Tim | Dave Side Projects | 404 | 26 |
13 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 844 | 31 |
17 | 1 | 8/20/1998 12:00:00 AM | 453054746 | DMB | DMB | 1 | 21 |
17 | 2 | 4/29/1996 12:00:00 AM | 453056601 | Dave solo | Dave Side Projects | 844 | 31 |
17 | 3 | 7/13/1997 12:00:00 AM | 453054985 | Dave & Tim | Dave Side Projects | 404 | 26 |
41 | 1 | 8/20/1998 12:00:00 AM | 453054746 | DMB | DMB | 1 | 21 |
41 | 2 | 6/3/1996 12:00:00 AM | 453055023 | Dave solo | Dave Side Projects | 809 | 31 |
41 | 3 | 7/13/1997 12:00:00 AM | 453054985 | Dave & Tim | Dave Side Projects | 404 | 26 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 844 | 31 |
42 | 1 | 6/7/1998 12:00:00 AM | 453054709 | DMB | DMB | 75 | 19 |
49 | 2 | 7/1/1998 12:00:00 AM | 453056508 | Dave solo | Dave Side Projects | 51 | 23 |
55 | 1 | 8/20/1998 12:00:00 AM | 453054746 | DMB | DMB | 1 | 21 |
96 | 2 | 7/1/1998 12:00:00 AM | 453056508 | Dave solo | Dave Side Projects | 51 | 23 |
96 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 544 | 24 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 1960 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | Openers and Collaborators | 2023 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 1583 | 1133 |
155 | 1 | 8/20/1998 12:00:00 AM | 453054746 | DMB | DMB | 1 | 21 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
2 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 2717 | 65 |
2 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 2302 | 57 |
2 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1947 | 53 |
5 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 2717 | 65 |
5 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 2302 | 57 |
5 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1947 | 53 |
6 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 2547 | 65 |
6 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 2170 | 57 |
6 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1947 | 53 |
6 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 1680 | 63 |
9 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 2717 | 65 |
9 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 2170 | 57 |
9 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1947 | 53 |
12 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 2547 | 65 |
12 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 2170 | 57 |
12 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1947 | 53 |
13 | 1 | 4/5/1992 12:00:00 AM | 453055729 | DMB | DMB | 2329 | 56 |
13 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 2170 | 57 |
13 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1947 | 53 |
13 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 1345 | 52 |
17 | 1 | 10/22/1991 12:00:00 AM | 453055864 | DMB | DMB | 2495 | 65 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 2170 | 57 |
17 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1947 | 53 |
41 | 1 | 4/7/1995 12:00:00 AM | 453055187 | DMB | DMB | 1232 | 37 |
41 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 859 | 31 |
41 | 3 | 2/1/1996 12:00:00 AM | 453054992 | Dave & Tim | Dave Side Projects | 932 | 27 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 844 | 31 |
42 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 125 | 23 |
49 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 125 | 23 |
49 | 2 | 7/1/1998 12:00:00 AM | 453056508 | Dave solo | Dave Side Projects | 51 | 23 |
55 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 125 | 23 |
56 | 1 | 11/29/1994 12:00:00 AM | 453055320 | DMB | DMB | 1361 | 45 |
57 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 125 | 23 |
59 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 125 | 23 |
96 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 2547 | 65 |
96 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 2302 | 57 |
96 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1947 | 53 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 1960 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | Openers and Collaborators | 2023 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 1583 | 1133 |
155 | 1 | 5/15/1998 12:00:00 AM | 453054694 | DMB | DMB | 98 | 19 |