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 = 453054974 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/27/1997' OR (SongInfo.ShowDate = '6/27/1997' AND SongInfo.ShowID < 453054974)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 340.464
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
4 | 1 | 6/26/1997 12:00:00 AM | 453054973 | DMB | DMB | 1 | 25 |
4 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 439 | 31 |
4 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
5 | 1 | 6/23/1997 12:00:00 AM | 453054971 | DMB | DMB | 4 | 25 |
5 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 439 | 31 |
5 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
6 | 1 | 6/26/1997 12:00:00 AM | 453054973 | DMB | DMB | 1 | 25 |
6 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 439 | 31 |
6 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
6 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 805 | 41 |
9 | 1 | 6/22/1997 12:00:00 AM | 453054970 | DMB | DMB | 5 | 25 |
9 | 2 | 1/24/1997 12:00:00 AM | 453055937 | Dave solo | Dave Side Projects | 154 | 26 |
9 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
13 | 1 | 6/26/1997 12:00:00 AM | 453054973 | DMB | DMB | 1 | 25 |
13 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 439 | 31 |
13 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
13 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 424 | 31 |
17 | 1 | 6/26/1997 12:00:00 AM | 453054973 | DMB | DMB | 1 | 25 |
17 | 2 | 4/29/1996 12:00:00 AM | 453056601 | Dave solo | Dave Side Projects | 424 | 31 |
17 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
18 | 1 | 6/22/1997 12:00:00 AM | 453054970 | DMB | DMB | 5 | 25 |
18 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 1515 | 53 |
18 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
20 | 1 | 6/25/1997 12:00:00 AM | 453054972 | DMB | DMB | 2 | 25 |
20 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 439 | 31 |
20 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 925 | 52 |
20 | 15 | 4/14/1995 12:00:00 AM | 453055192 | Dave & Boyd | DMB | 805 | 41 |
21 | 1 | 6/26/1997 12:00:00 AM | 453054973 | DMB | DMB | 1 | 25 |
21 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 439 | 31 |
21 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
22 | 1 | 6/26/1997 12:00:00 AM | 453054973 | DMB | DMB | 1 | 25 |
22 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 439 | 31 |
22 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
22 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 1540 | 53 |
22 | 15 | 10/29/1994 12:00:00 AM | 453089864 | Dave & Boyd | DMB | 972 | 63 |
27 | 1 | 6/19/1997 12:00:00 AM | 453054968 | DMB | DMB | 8 | 25 |
27 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 439 | 31 |
27 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
30 | 1 | 6/22/1997 12:00:00 AM | 453054970 | DMB | DMB | 5 | 25 |
30 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 439 | 31 |
30 | 3 | 2/22/1997 12:00:00 AM | 453054954 | Dave & Tim | Dave Side Projects | 125 | 24 |
30 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 925 | 52 |
37 | 1 | 6/26/1997 12:00:00 AM | 453054973 | DMB | DMB | 1 | 25 |
37 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 439 | 31 |
37 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
37 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 925 | 52 |
41 | 1 | 6/26/1997 12:00:00 AM | 453054973 | DMB | DMB | 1 | 25 |
41 | 2 | 6/3/1996 12:00:00 AM | 453055023 | Dave solo | Dave Side Projects | 389 | 31 |
41 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 424 | 31 |
46 | 1 | 6/26/1997 12:00:00 AM | 453054973 | DMB | DMB | 1 | 25 |
46 | 2 | 5/27/1996 12:00:00 AM | 453090935 | Dave solo | Dave Side Projects | 396 | 31 |
46 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
46 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 424 | 31 |
46 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 679 | 41 |
47 | 1 | 6/26/1997 12:00:00 AM | 453054973 | DMB | DMB | 1 | 25 |
47 | 3 | 2/23/1997 12:00:00 AM | 453054955 | Dave & Tim | Dave Side Projects | 124 | 24 |
47 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 424 | 31 |
92 | 1 | 6/26/1997 12:00:00 AM | 453054973 | DMB | DMB | 1 | 25 |
167 | 3 | 2/17/1997 12:00:00 AM | 453054950 | Dave & Tim | Dave Side Projects | 130 | 24 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
4 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 2297 | 65 |
4 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1882 | 57 |
4 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1527 | 53 |
5 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 2297 | 65 |
5 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1882 | 57 |
5 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1527 | 53 |
6 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 2127 | 65 |
6 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 1750 | 57 |
6 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1527 | 53 |
6 | 15 | 1/14/1994 12:00:00 AM | 453055373 | Dave & Boyd | DMB | 1260 | 63 |
9 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 2297 | 65 |
9 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 1750 | 57 |
9 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1527 | 53 |
13 | 1 | 4/5/1992 12:00:00 AM | 453055729 | DMB | DMB | 1909 | 56 |
13 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 1750 | 57 |
13 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1527 | 53 |
13 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 925 | 52 |
17 | 1 | 10/22/1991 12:00:00 AM | 453055864 | DMB | DMB | 2075 | 65 |
17 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 1750 | 57 |
17 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1527 | 53 |
18 | 1 | 9/20/1991 12:00:00 AM | 453056809 | DMB | DMB | 2107 | 65 |
18 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1882 | 57 |
18 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1527 | 53 |
20 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 2127 | 65 |
20 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 1882 | 57 |
20 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1527 | 53 |
20 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 925 | 52 |
20 | 15 | 3/10/1994 12:00:00 AM | 453089625 | Dave & Boyd | DMB | 1205 | 52 |
21 | 1 | 2/13/1992 12:00:00 AM | 453055738 | DMB | DMB | 1961 | 56 |
21 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 1750 | 57 |
21 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1527 | 53 |
22 | 1 | 3/1/1992 12:00:00 AM | 453055741 | DMB | DMB | 1944 | 56 |
22 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 1750 | 57 |
22 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1527 | 53 |
22 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 1540 | 53 |
22 | 15 | 3/10/1994 12:00:00 AM | 453089625 | Dave & Boyd | DMB | 1205 | 52 |
27 | 1 | 6/9/1992 12:00:00 AM | 453055657 | DMB | DMB | 1844 | 56 |
27 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 439 | 31 |
27 | 3 | 6/13/1993 12:00:00 AM | 453056928 | Dave & Tim | Dave Side Projects | 1475 | 53 |
30 | 1 | 11/17/1992 12:00:00 AM | 453055606 | DMB | DMB | 1683 | 56 |
30 | 2 | 5/4/1993 12:00:00 AM | 453055554 | Dave solo | Dave Side Projects | 1515 | 53 |
30 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 1527 | 53 |
30 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 925 | 52 |
37 | 1 | 10/15/1993 12:00:00 AM | 453055455 | DMB | DMB | 1351 | 51 |
37 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 439 | 31 |
37 | 3 | 12/12/1993 12:00:00 AM | 453055494 | Dave & Tim | Dave Side Projects | 1293 | 53 |
37 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 925 | 52 |
41 | 1 | 4/7/1995 12:00:00 AM | 453055187 | DMB | DMB | 812 | 37 |
41 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 439 | 31 |
41 | 3 | 2/1/1996 12:00:00 AM | 453054992 | Dave & Tim | Dave Side Projects | 512 | 27 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 424 | 31 |
46 | 1 | 10/4/1995 12:00:00 AM | 453055261 | DMB | DMB | 632 | 41 |
46 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 439 | 31 |
46 | 3 | 9/24/1995 12:00:00 AM | 453055259 | Dave & Tim | Dave Side Projects | 642 | 41 |
46 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 424 | 31 |
46 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 679 | 41 |
47 | 1 | 10/4/1995 12:00:00 AM | 453055261 | DMB | DMB | 632 | 41 |
47 | 3 | 12/16/1996 12:00:00 AM | 453055128 | Dave & Tim | Dave Side Projects | 193 | 31 |
47 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 424 | 31 |
92 | 1 | 10/3/1996 12:00:00 AM | 453055078 | DMB | DMB | 267 | 29 |
167 | 1 | 6/6/1997 12:00:00 AM | 453054958 | DMB | DMB | 21 | 25 |
167 | 3 | 2/18/1996 12:00:00 AM | 453055005 | Dave & Tim | Dave Side Projects | 495 | 27 |