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 = 453055255 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/31/1995' OR (SongInfo.ShowDate = '8/31/1995' AND SongInfo.ShowID < 453055255)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 311.0348
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
3 | 1 | 8/26/1995 12:00:00 AM | 453055252 | DMB | DMB | 5 | 38 |
3 | 2 | 8/10/1994 12:00:00 AM | 453056434 | Dave solo | Dave Side Projects | 386 | 52 |
3 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 297 | 52 |
3 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 259 | 52 |
3 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 594 | 63 |
4 | 1 | 8/29/1995 12:00:00 AM | 453055254 | DMB | DMB | 2 | 38 |
4 | 2 | 8/10/1994 12:00:00 AM | 453056434 | Dave solo | Dave Side Projects | 386 | 52 |
4 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 297 | 52 |
5 | 1 | 8/29/1995 12:00:00 AM | 453055254 | DMB | DMB | 2 | 38 |
5 | 2 | 12/28/1993 12:00:00 AM | 453055435 | Dave solo | Dave Side Projects | 611 | 53 |
5 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 297 | 52 |
6 | 1 | 8/27/1995 12:00:00 AM | 453055253 | DMB | DMB | 4 | 38 |
6 | 2 | 5/7/1994 12:00:00 AM | 453055405 | Dave solo | Dave Side Projects | 481 | 52 |
6 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 297 | 52 |
6 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 139 | 41 |
8 | 1 | 8/29/1995 12:00:00 AM | 453055254 | DMB | DMB | 2 | 38 |
8 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 1084 | 57 |
11 | 1 | 8/29/1995 12:00:00 AM | 453055254 | DMB | DMB | 2 | 38 |
11 | 2 | 8/10/1994 12:00:00 AM | 453056434 | Dave solo | Dave Side Projects | 386 | 52 |
11 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 297 | 52 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 594 | 63 |
13 | 1 | 8/29/1995 12:00:00 AM | 453055254 | DMB | DMB | 2 | 38 |
13 | 2 | 12/28/1993 12:00:00 AM | 453055435 | Dave solo | Dave Side Projects | 611 | 53 |
13 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 297 | 52 |
13 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 259 | 52 |
17 | 1 | 8/29/1995 12:00:00 AM | 453055254 | DMB | DMB | 2 | 38 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 1084 | 57 |
17 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 297 | 52 |
18 | 1 | 8/25/1995 12:00:00 AM | 453055251 | DMB | DMB | 6 | 38 |
18 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 849 | 53 |
18 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 297 | 52 |
19 | 1 | 8/29/1995 12:00:00 AM | 453055254 | DMB | DMB | 2 | 38 |
19 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 297 | 52 |
19 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 259 | 52 |
20 | 1 | 8/29/1995 12:00:00 AM | 453055254 | DMB | DMB | 2 | 38 |
20 | 2 | 8/10/1994 12:00:00 AM | 453056434 | Dave solo | Dave Side Projects | 386 | 52 |
20 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 297 | 52 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 259 | 52 |
20 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 139 | 41 |
28 | 1 | 8/29/1995 12:00:00 AM | 453055254 | DMB | DMB | 2 | 38 |
28 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 259 | 52 |
30 | 1 | 8/9/1995 12:00:00 AM | 453055239 | DMB | DMB | 22 | 38 |
30 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 849 | 53 |
30 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 809 | 53 |
30 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 259 | 52 |
33 | 1 | 8/29/1995 12:00:00 AM | 453055254 | DMB | DMB | 2 | 38 |
33 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 297 | 52 |
33 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 139 | 41 |
41 | 1 | 8/20/1995 12:00:00 AM | 453055247 | DMB | DMB | 11 | 38 |
96 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1216 | 57 |
96 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 297 | 52 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 874 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | Openers and Collaborators | 937 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 497 | 1133 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
3 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 1631 | 65 |
3 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1216 | 57 |
3 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 861 | 53 |
3 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 259 | 52 |
3 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 594 | 63 |
4 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 1631 | 65 |
4 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1216 | 57 |
4 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 861 | 53 |
5 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 1631 | 65 |
5 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1216 | 57 |
5 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 861 | 53 |
6 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 1461 | 65 |
6 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 1084 | 57 |
6 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 861 | 53 |
6 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 594 | 63 |
8 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 1461 | 65 |
8 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1216 | 57 |
11 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 1461 | 65 |
11 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 1084 | 57 |
11 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 861 | 53 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 594 | 63 |
13 | 1 | 4/5/1992 12:00:00 AM | 453055729 | DMB | DMB | 1243 | 56 |
13 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 1084 | 57 |
13 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 861 | 53 |
13 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 259 | 52 |
17 | 1 | 10/22/1991 12:00:00 AM | 453055864 | DMB | DMB | 1409 | 65 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 1084 | 57 |
17 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 861 | 53 |
18 | 1 | 9/20/1991 12:00:00 AM | 453056809 | DMB | DMB | 1441 | 65 |
18 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1216 | 57 |
18 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 861 | 53 |
19 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 1461 | 65 |
19 | 3 | 9/26/1994 12:00:00 AM | 453055276 | Dave & Tim | Dave Side Projects | 339 | 52 |
19 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 259 | 52 |
20 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 1461 | 65 |
20 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1216 | 57 |
20 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 861 | 53 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 259 | 52 |
20 | 15 | 3/10/1994 12:00:00 AM | 453089625 | Dave & Boyd | DMB | 539 | 52 |
28 | 1 | 7/8/1992 12:00:00 AM | 453055671 | DMB | DMB | 1149 | 56 |
28 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 259 | 52 |
30 | 1 | 11/17/1992 12:00:00 AM | 453055606 | DMB | DMB | 1017 | 56 |
30 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 849 | 53 |
30 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 861 | 53 |
30 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 259 | 52 |
33 | 1 | 1/19/1993 12:00:00 AM | 453055496 | DMB | DMB | 954 | 51 |
33 | 3 | 5/4/1994 12:00:00 AM | 453055404 | Dave & Tim | Dave Side Projects | 484 | 52 |
33 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 139 | 41 |
41 | 1 | 4/7/1995 12:00:00 AM | 453055187 | DMB | DMB | 146 | 37 |
44 | 1 | 12/16/1994 12:00:00 AM | 453056378 | DMB | DMB | 258 | 45 |
96 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 1461 | 65 |
96 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1216 | 57 |
96 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 861 | 53 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 874 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | Openers and Collaborators | 937 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | Openers and Collaborators | 497 | 1133 |