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 = 453055479 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 < '11/23/1993' OR (SongInfo.ShowDate = '11/23/1993' AND SongInfo.ShowID < 453055479)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 271.0711
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
2 | 1 | 11/20/1993 12:00:00 AM | 453055478 | DMB | DMB | 3 | 51 |
2 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 570 | 57 |
2 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 163 | 53 |
3 | 1 | 11/20/1993 12:00:00 AM | 453055478 | DMB | DMB | 3 | 51 |
3 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 203 | 53 |
3 | 3 | 7/26/1993 12:00:00 AM | 453055589 | Dave & Tim | Dave Side Projects | 120 | 53 |
4 | 1 | 11/19/1993 12:00:00 AM | 453055477 | DMB | DMB | 4 | 51 |
4 | 2 | 4/5/1993 12:00:00 AM | 453055539 | Dave solo | Dave Side Projects | 232 | 53 |
4 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 163 | 53 |
6 | 1 | 11/20/1993 12:00:00 AM | 453055478 | DMB | DMB | 3 | 51 |
6 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 438 | 57 |
6 | 3 | 7/26/1993 12:00:00 AM | 453055589 | Dave & Tim | Dave Side Projects | 120 | 53 |
8 | 1 | 11/17/1993 12:00:00 AM | 453055476 | DMB | DMB | 6 | 51 |
8 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 438 | 57 |
10 | 1 | 11/20/1993 12:00:00 AM | 453055478 | DMB | DMB | 3 | 51 |
11 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 203 | 53 |
11 | 3 | 7/26/1993 12:00:00 AM | 453055589 | Dave & Tim | Dave Side Projects | 120 | 53 |
12 | 1 | 11/20/1993 12:00:00 AM | 453055478 | DMB | DMB | 3 | 51 |
12 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 438 | 57 |
12 | 3 | 7/26/1993 12:00:00 AM | 453055589 | Dave & Tim | Dave Side Projects | 120 | 53 |
15 | 1 | 11/13/1993 12:00:00 AM | 453055474 | DMB | DMB | 10 | 51 |
15 | 12 | 1/12/1993 12:00:00 AM | 453055495 | C-ville Allstars | Carter Side Projects | 315 | 53 |
17 | 1 | 11/20/1993 12:00:00 AM | 453055478 | DMB | DMB | 3 | 51 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 438 | 57 |
17 | 3 | 7/26/1993 12:00:00 AM | 453055589 | Dave & Tim | Dave Side Projects | 120 | 53 |
18 | 1 | 11/20/1993 12:00:00 AM | 453055478 | DMB | DMB | 3 | 51 |
18 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 203 | 53 |
18 | 3 | 7/26/1993 12:00:00 AM | 453055589 | Dave & Tim | Dave Side Projects | 120 | 53 |
20 | 1 | 11/20/1993 12:00:00 AM | 453055478 | DMB | DMB | 3 | 51 |
20 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 203 | 53 |
20 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 163 | 53 |
22 | 1 | 11/20/1993 12:00:00 AM | 453055478 | DMB | DMB | 3 | 51 |
22 | 2 | 4/5/1993 12:00:00 AM | 453055539 | Dave solo | Dave Side Projects | 232 | 53 |
22 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 163 | 53 |
22 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 228 | 53 |
24 | 1 | 11/20/1993 12:00:00 AM | 453055478 | DMB | DMB | 3 | 51 |
24 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 438 | 57 |
24 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 163 | 53 |
30 | 1 | 11/20/1993 12:00:00 AM | 453055478 | DMB | DMB | 3 | 51 |
30 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 203 | 53 |
30 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 163 | 53 |
37 | 1 | 11/20/1993 12:00:00 AM | 453055478 | DMB | DMB | 3 | 51 |
98 | 2 | 4/5/1993 12:00:00 AM | 453055539 | Dave solo | Dave Side Projects | 232 | 53 |
98 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 163 | 53 |
98 | 12 | 7/3/1993 12:00:00 AM | 453089752 | C-ville Allstars | Carter Side Projects | 143 | 53 |
98 | 10141 | 5/4/1993 12:00:00 AM | 453079541 | Boyd & Co. | Boyd Side Projects | 203 | 1132 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
2 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 985 | 65 |
2 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 570 | 57 |
2 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 215 | 53 |
3 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 985 | 65 |
3 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 570 | 57 |
3 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 215 | 53 |
4 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 985 | 65 |
4 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 570 | 57 |
4 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 215 | 53 |
6 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 815 | 65 |
6 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 438 | 57 |
6 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 215 | 53 |
8 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 815 | 65 |
8 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 570 | 57 |
10 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 815 | 65 |
11 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 815 | 65 |
11 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 438 | 57 |
11 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 215 | 53 |
12 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 815 | 65 |
12 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 438 | 57 |
12 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 215 | 53 |
15 | 1 | 10/21/1991 12:00:00 AM | 453056605 | DMB | DMB | 764 | 65 |
15 | 12 | 1/6/1993 12:00:00 AM | 453056967 | C-ville Allstars | Carter Side Projects | 321 | 53 |
17 | 1 | 10/22/1991 12:00:00 AM | 453055864 | DMB | DMB | 763 | 65 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 438 | 57 |
17 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 215 | 53 |
18 | 1 | 9/20/1991 12:00:00 AM | 453056809 | DMB | DMB | 795 | 65 |
18 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 570 | 57 |
18 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 215 | 53 |
20 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 815 | 65 |
20 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 570 | 57 |
20 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 215 | 53 |
22 | 1 | 3/1/1992 12:00:00 AM | 453055741 | DMB | DMB | 632 | 56 |
22 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 438 | 57 |
22 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 215 | 53 |
22 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 228 | 53 |
24 | 1 | 5/26/1992 12:00:00 AM | 453055649 | DMB | DMB | 546 | 56 |
24 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 438 | 57 |
24 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 215 | 53 |
30 | 1 | 11/17/1992 12:00:00 AM | 453055606 | DMB | DMB | 371 | 56 |
30 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 203 | 53 |
30 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 215 | 53 |
37 | 1 | 10/15/1993 12:00:00 AM | 453055455 | DMB | DMB | 39 | 51 |
98 | 1 | 10/22/1991 12:00:00 AM | 453055864 | DMB | DMB | 763 | 65 |
98 | 2 | 4/5/1993 12:00:00 AM | 453055539 | Dave solo | Dave Side Projects | 232 | 53 |
98 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 215 | 53 |
98 | 12 | 1/6/1993 12:00:00 AM | 453056967 | C-ville Allstars | Carter Side Projects | 321 | 53 |
98 | 10141 | 5/4/1993 12:00:00 AM | 453079541 | Boyd & Co. | Boyd Side Projects | 203 | 1132 |