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 = 453055139 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 < '1/28/1995' OR (SongInfo.ShowDate = '1/28/1995' AND SongInfo.ShowID < 453055139)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 222.8074
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
2 | 1 | 12/31/1994 12:00:00 AM | 453055275 | DMB | DMB | 28 | 44 |
2 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1001 | 57 |
2 | 3 | 5/4/1994 12:00:00 AM | 453055404 | Dave & Tim | Dave Side Projects | 269 | 52 |
4 | 1 | 1/26/1995 12:00:00 AM | 453055137 | DMB | DMB | 2 | 36 |
4 | 2 | 8/10/1994 12:00:00 AM | 453056434 | Dave solo | Dave Side Projects | 171 | 52 |
4 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 82 | 52 |
11 | 1 | 1/27/1995 12:00:00 AM | 453055138 | DMB | DMB | 1 | 36 |
11 | 2 | 8/10/1994 12:00:00 AM | 453056434 | Dave solo | Dave Side Projects | 171 | 52 |
11 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 82 | 52 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 379 | 63 |
17 | 1 | 1/27/1995 12:00:00 AM | 453055138 | DMB | DMB | 1 | 36 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 869 | 57 |
17 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 82 | 52 |
18 | 1 | 12/29/1994 12:00:00 AM | 453055273 | DMB | DMB | 30 | 44 |
18 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 634 | 53 |
18 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 82 | 52 |
19 | 1 | 1/27/1995 12:00:00 AM | 453055138 | DMB | DMB | 1 | 36 |
19 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 82 | 52 |
19 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 44 | 52 |
20 | 1 | 1/27/1995 12:00:00 AM | 453055138 | DMB | DMB | 1 | 36 |
20 | 2 | 8/10/1994 12:00:00 AM | 453056434 | Dave solo | Dave Side Projects | 171 | 52 |
20 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 82 | 52 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 44 | 52 |
20 | 15 | 10/29/1994 12:00:00 AM | 453089864 | Dave & Boyd | DMB | 91 | 63 |
27 | 1 | 1/26/1995 12:00:00 AM | 453055137 | DMB | DMB | 2 | 36 |
27 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 594 | 53 |
36 | 1 | 1/27/1995 12:00:00 AM | 453055138 | DMB | DMB | 1 | 36 |
36 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 82 | 52 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
2 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 1416 | 65 |
2 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1001 | 57 |
2 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 646 | 53 |
4 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 1416 | 65 |
4 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1001 | 57 |
4 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 646 | 53 |
11 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 1246 | 65 |
11 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 869 | 57 |
11 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 646 | 53 |
11 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 379 | 63 |
17 | 1 | 10/22/1991 12:00:00 AM | 453055864 | DMB | DMB | 1194 | 65 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 869 | 57 |
17 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 646 | 53 |
18 | 1 | 9/20/1991 12:00:00 AM | 453056809 | DMB | DMB | 1226 | 65 |
18 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1001 | 57 |
18 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 646 | 53 |
19 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 1246 | 65 |
19 | 3 | 9/26/1994 12:00:00 AM | 453055276 | Dave & Tim | Dave Side Projects | 124 | 52 |
19 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 44 | 52 |
20 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 1246 | 65 |
20 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1001 | 57 |
20 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 646 | 53 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 44 | 52 |
20 | 15 | 3/10/1994 12:00:00 AM | 453089625 | Dave & Boyd | DMB | 324 | 52 |
27 | 1 | 6/9/1992 12:00:00 AM | 453055657 | DMB | DMB | 963 | 56 |
27 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 594 | 53 |
36 | 1 | 4/14/1993 12:00:00 AM | 453055545 | DMB | DMB | 654 | 51 |
36 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 82 | 52 |