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 = 453054700 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/25/1998' OR (SongInfo.ShowDate = '5/25/1998' AND SongInfo.ShowID < 453054700)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 372.6492
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
2 | 1 | 5/15/1998 12:00:00 AM | 453054694 | DMB | DMB | 10 | 19 |
2 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 771 | 31 |
2 | 3 | 7/13/1997 12:00:00 AM | 453054985 | Dave & Tim | Dave Side Projects | 316 | 26 |
3 | 1 | 5/21/1998 12:00:00 AM | 453054697 | DMB | DMB | 4 | 19 |
3 | 2 | 1/24/1997 12:00:00 AM | 453055937 | Dave solo | Dave Side Projects | 486 | 26 |
3 | 3 | 7/13/1997 12:00:00 AM | 453054985 | Dave & Tim | Dave Side Projects | 316 | 26 |
3 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 1257 | 52 |
3 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 1592 | 63 |
6 | 1 | 5/24/1998 12:00:00 AM | 453054699 | DMB | DMB | 1 | 19 |
6 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 771 | 31 |
6 | 3 | 7/13/1997 12:00:00 AM | 453054985 | Dave & Tim | Dave Side Projects | 316 | 26 |
6 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 1137 | 41 |
11 | 1 | 5/23/1998 12:00:00 AM | 453054698 | DMB | DMB | 2 | 19 |
11 | 2 | 4/29/1996 12:00:00 AM | 453056601 | Dave solo | Dave Side Projects | 756 | 31 |
11 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 456 | 24 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 1592 | 63 |
13 | 1 | 5/24/1998 12:00:00 AM | 453054699 | DMB | DMB | 1 | 19 |
13 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 771 | 31 |
13 | 3 | 7/13/1997 12:00:00 AM | 453054985 | Dave & Tim | Dave Side Projects | 316 | 26 |
13 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 756 | 31 |
15 | 1 | 5/23/1998 12:00:00 AM | 453054698 | DMB | DMB | 2 | 19 |
15 | 12 | 1/12/1993 12:00:00 AM | 453055495 | C-ville Allstars | Carter Side Projects | 1959 | 53 |
19 | 1 | 5/23/1998 12:00:00 AM | 453054698 | DMB | DMB | 2 | 19 |
19 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 771 | 31 |
19 | 3 | 7/13/1997 12:00:00 AM | 453054985 | Dave & Tim | Dave Side Projects | 316 | 26 |
19 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 756 | 31 |
21 | 1 | 5/23/1998 12:00:00 AM | 453054698 | DMB | DMB | 2 | 19 |
21 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 771 | 31 |
21 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 456 | 24 |
42 | 1 | 5/17/1998 12:00:00 AM | 453054695 | DMB | DMB | 8 | 19 |
96 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 771 | 31 |
96 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 456 | 24 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 1872 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | Openers and Collaborators | 1935 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 1495 | 1133 |
155 | 1 | 5/24/1998 12:00:00 AM | 453054699 | DMB | DMB | 1 | 19 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
2 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 2629 | 65 |
2 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 2214 | 57 |
2 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1859 | 53 |
3 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 2629 | 65 |
3 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 2214 | 57 |
3 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1859 | 53 |
3 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 1257 | 52 |
3 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 1592 | 63 |
6 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 2459 | 65 |
6 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 2082 | 57 |
6 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1859 | 53 |
6 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 1592 | 63 |
11 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 2459 | 65 |
11 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 2082 | 57 |
11 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1859 | 53 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 1592 | 63 |
13 | 1 | 4/5/1992 12:00:00 AM | 453055729 | DMB | DMB | 2241 | 56 |
13 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 2082 | 57 |
13 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1859 | 53 |
13 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 1257 | 52 |
15 | 1 | 10/21/1991 12:00:00 AM | 453056605 | DMB | DMB | 2408 | 65 |
15 | 12 | 1/6/1993 12:00:00 AM | 453056967 | C-ville Allstars | Carter Side Projects | 1965 | 53 |
19 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 2459 | 65 |
19 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 771 | 31 |
19 | 3 | 9/26/1994 12:00:00 AM | 453055276 | Dave & Tim | Dave Side Projects | 1337 | 52 |
19 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 1257 | 52 |
21 | 1 | 2/13/1992 12:00:00 AM | 453055738 | DMB | DMB | 2293 | 56 |
21 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 2082 | 57 |
21 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1859 | 53 |
42 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 37 | 23 |
49 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 37 | 23 |
55 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 37 | 23 |
56 | 1 | 11/29/1994 12:00:00 AM | 453055320 | DMB | DMB | 1273 | 45 |
57 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 37 | 23 |
59 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 37 | 23 |
60 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 37 | 23 |
96 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 2459 | 65 |
96 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 2214 | 57 |
96 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1859 | 53 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 1872 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | Openers and Collaborators | 1935 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 1495 | 1133 |
155 | 1 | 5/15/1998 12:00:00 AM | 453054694 | DMB | DMB | 10 | 19 |