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 = 453055466 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/2/1993' OR (SongInfo.ShowDate = '11/2/1993' AND SongInfo.ShowID < 453055466)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 339.6763
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
1 | 1 | 10/26/1993 12:00:00 AM | 453055462 | DMB | DMB | 7 | 51 |
1 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 417 | 57 |
1 | 3 | 7/26/1993 12:00:00 AM | 453055589 | Dave & Tim | Dave Side Projects | 99 | 53 |
2 | 1 | 10/30/1993 12:00:00 AM | 453055464 | DMB | DMB | 3 | 51 |
2 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 549 | 57 |
2 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 142 | 53 |
4 | 1 | 10/22/1993 12:00:00 AM | 453055459 | DMB | DMB | 11 | 51 |
4 | 2 | 4/5/1993 12:00:00 AM | 453055539 | Dave solo | Dave Side Projects | 211 | 53 |
4 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 142 | 53 |
5 | 1 | 10/22/1993 12:00:00 AM | 453055459 | DMB | DMB | 11 | 51 |
5 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 549 | 57 |
5 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 142 | 53 |
8 | 1 | 2/17/1993 12:00:00 AM | 453055514 | DMB | DMB | 258 | 51 |
8 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 417 | 57 |
9 | 1 | 10/30/1993 12:00:00 AM | 453055464 | DMB | DMB | 3 | 51 |
9 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 182 | 53 |
9 | 3 | 7/26/1993 12:00:00 AM | 453055589 | Dave & Tim | Dave Side Projects | 99 | 53 |
10 | 1 | 10/30/1993 12:00:00 AM | 453055464 | DMB | DMB | 3 | 51 |
13 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 417 | 57 |
13 | 3 | 5/23/1993 12:00:00 AM | 453055561 | Dave & Tim | Dave Side Projects | 163 | 53 |
15 | 1 | 10/30/1993 12:00:00 AM | 453055464 | DMB | DMB | 3 | 51 |
15 | 12 | 1/12/1993 12:00:00 AM | 453055495 | C-ville Allstars | Carter Side Projects | 294 | 53 |
17 | 1 | 10/30/1993 12:00:00 AM | 453055464 | DMB | DMB | 3 | 51 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 417 | 57 |
17 | 3 | 7/26/1993 12:00:00 AM | 453055589 | Dave & Tim | Dave Side Projects | 99 | 53 |
19 | 1 | 10/30/1993 12:00:00 AM | 453055464 | DMB | DMB | 3 | 51 |
22 | 2 | 4/5/1993 12:00:00 AM | 453055539 | Dave solo | Dave Side Projects | 211 | 53 |
22 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 142 | 53 |
22 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 207 | 53 |
27 | 1 | 10/30/1993 12:00:00 AM | 453055464 | DMB | DMB | 3 | 51 |
27 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 142 | 53 |
30 | 1 | 10/30/1993 12:00:00 AM | 453055464 | DMB | DMB | 3 | 51 |
30 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 182 | 53 |
30 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 142 | 53 |
33 | 1 | 10/15/1993 12:00:00 AM | 453055455 | DMB | DMB | 18 | 51 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
1 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 964 | 65 |
1 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 417 | 57 |
1 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 194 | 53 |
2 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 964 | 65 |
2 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 549 | 57 |
2 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 194 | 53 |
4 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 964 | 65 |
4 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 549 | 57 |
4 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 194 | 53 |
5 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 964 | 65 |
5 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 549 | 57 |
5 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 194 | 53 |
8 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 794 | 65 |
8 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 549 | 57 |
9 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 964 | 65 |
9 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 417 | 57 |
9 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 194 | 53 |
10 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 794 | 65 |
13 | 1 | 4/5/1992 12:00:00 AM | 453055729 | DMB | DMB | 576 | 56 |
13 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 417 | 57 |
13 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 194 | 53 |
15 | 1 | 10/21/1991 12:00:00 AM | 453056605 | DMB | DMB | 743 | 65 |
15 | 12 | 1/6/1993 12:00:00 AM | 453056967 | C-ville Allstars | Carter Side Projects | 300 | 53 |
17 | 1 | 10/22/1991 12:00:00 AM | 453055864 | DMB | DMB | 742 | 65 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 417 | 57 |
17 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 194 | 53 |
19 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 794 | 65 |
22 | 1 | 3/1/1992 12:00:00 AM | 453055741 | DMB | DMB | 611 | 56 |
22 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 417 | 57 |
22 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 194 | 53 |
22 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 207 | 53 |
27 | 1 | 6/9/1992 12:00:00 AM | 453055657 | DMB | DMB | 511 | 56 |
27 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 142 | 53 |
30 | 1 | 11/17/1992 12:00:00 AM | 453055606 | DMB | DMB | 350 | 56 |
30 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 182 | 53 |
30 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 194 | 53 |
33 | 1 | 1/19/1993 12:00:00 AM | 453055496 | DMB | DMB | 287 | 51 |
37 | 1 | 10/15/1993 12:00:00 AM | 453055455 | DMB | DMB | 18 | 51 |
91 | 1 | 8/31/1993 12:00:00 AM | 453055441 | DMB | DMB | 63 | 51 |
172 | 1 | 7/6/1993 12:00:00 AM | 453055580 | DMB | DMB | 119 | 51 |