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 = 453055657 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 < '6/9/1992' OR (SongInfo.ShowDate = '6/9/1992' AND SongInfo.ShowID < 453055657)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 433.6955
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
1 | 1 | 5/5/1992 12:00:00 AM | 453055636 | DMB | DMB | 35 | 57 |
2 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
3 | 1 | 5/26/1992 12:00:00 AM | 453055649 | DMB | DMB | 14 | 56 |
3 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
4 | 1 | 5/26/1992 12:00:00 AM | 453055649 | DMB | DMB | 14 | 56 |
4 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
5 | 1 | 5/14/1992 12:00:00 AM | 453055961 | DMB | DMB | 26 | 56 |
5 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
6 | 1 | 5/26/1992 12:00:00 AM | 453055649 | DMB | DMB | 14 | 56 |
8 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
9 | 1 | 5/20/1992 12:00:00 AM | 453055646 | DMB | DMB | 20 | 56 |
18 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
19 | 1 | 5/14/1992 12:00:00 AM | 453055961 | DMB | DMB | 26 | 56 |
20 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
21 | 1 | 5/26/1992 12:00:00 AM | 453055649 | DMB | DMB | 14 | 56 |
96 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
121 | 1 | 5/26/1992 12:00:00 AM | 453055649 | DMB | DMB | 14 | 56 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
1 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 453 | 65 |
2 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 453 | 65 |
2 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
3 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 453 | 65 |
3 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
4 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 453 | 65 |
4 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
5 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 453 | 65 |
5 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
6 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 283 | 65 |
8 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 283 | 65 |
8 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
9 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 453 | 65 |
10 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 283 | 65 |
11 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 283 | 65 |
12 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 283 | 65 |
13 | 1 | 4/5/1992 12:00:00 AM | 453055729 | DMB | DMB | 65 | 56 |
14 | 1 | 10/21/1991 12:00:00 AM | 453056605 | DMB | DMB | 232 | 65 |
15 | 1 | 10/21/1991 12:00:00 AM | 453056605 | DMB | DMB | 232 | 65 |
16 | 1 | 10/22/1991 12:00:00 AM | 453055864 | DMB | DMB | 231 | 65 |
17 | 1 | 10/22/1991 12:00:00 AM | 453055864 | DMB | DMB | 231 | 65 |
18 | 1 | 9/20/1991 12:00:00 AM | 453056809 | DMB | DMB | 263 | 65 |
18 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
19 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 283 | 65 |
20 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 283 | 65 |
20 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
21 | 1 | 2/13/1992 12:00:00 AM | 453055738 | DMB | DMB | 117 | 56 |
22 | 1 | 3/1/1992 12:00:00 AM | 453055741 | DMB | DMB | 100 | 56 |
24 | 1 | 5/26/1992 12:00:00 AM | 453055649 | DMB | DMB | 14 | 56 |
96 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 283 | 65 |
96 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 38 | 57 |
121 | 1 | 11/26/1991 12:00:00 AM | 453056168 | DMB | DMB | 196 | 65 |