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 = 453054411 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 < '7/11/2000' OR (SongInfo.ShowDate = '7/11/2000' AND SongInfo.ShowID < 453054411)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 347.4735
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
2 | 1 | 7/8/2000 12:00:00 AM | 453054409 | DMB | DMB | 3 | 13 |
2 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 1549 | 31 |
2 | 3 | 3/14/1999 12:00:00 AM | 453054613 | Dave & Tim | Dave Side Projects | 485 | 16 |
9 | 1 | 6/26/2000 12:00:00 AM | 453054403 | DMB | DMB | 15 | 13 |
9 | 2 | 10/27/1998 12:00:00 AM | 453056430 | Dave solo | Dave Side Projects | 623 | 34 |
9 | 3 | 3/3/1999 12:00:00 AM | 453054603 | Dave & Tim | Dave Side Projects | 496 | 16 |
10 | 1 | 7/8/2000 12:00:00 AM | 453054409 | DMB | DMB | 3 | 13 |
10 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 1549 | 31 |
10 | 3 | 2/6/1999 12:00:00 AM | 453054586 | Dave & Tim | Dave Side Projects | 521 | 16 |
10 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 1789 | 41 |
12 | 1 | 7/5/2000 12:00:00 AM | 453054408 | DMB | DMB | 6 | 13 |
12 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 1549 | 31 |
12 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | Dave Side Projects | 474 | 16 |
21 | 1 | 7/9/2000 12:00:00 AM | 453054410 | DMB | DMB | 2 | 13 |
21 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 1549 | 31 |
21 | 3 | 3/24/1999 12:00:00 AM | 453054614 | Dave & Tim | Dave Side Projects | 475 | 18 |
22 | 1 | 7/9/2000 12:00:00 AM | 453054410 | DMB | DMB | 2 | 13 |
22 | 2 | 12/11/1998 12:00:00 AM | 453056392 | Dave solo | Dave Side Projects | 578 | 34 |
22 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | Dave Side Projects | 474 | 16 |
22 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 2650 | 53 |
22 | 15 | 10/29/1994 12:00:00 AM | 453089864 | Dave & Boyd | DMB | 2082 | 63 |
36 | 1 | 7/3/2000 12:00:00 AM | 453054407 | DMB | DMB | 8 | 13 |
36 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 1549 | 31 |
36 | 3 | 2/1/1997 12:00:00 AM | 453054938 | Dave & Tim | Dave Side Projects | 1256 | 24 |
37 | 1 | 7/9/2000 12:00:00 AM | 453054410 | DMB | DMB | 2 | 13 |
37 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 1549 | 31 |
37 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | Dave Side Projects | 474 | 16 |
37 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 2035 | 52 |
41 | 1 | 7/8/2000 12:00:00 AM | 453054409 | DMB | DMB | 3 | 13 |
41 | 2 | 7/10/1999 12:00:00 AM | 453055891 | Dave solo | Dave Side Projects | 367 | 62 |
41 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | Dave Side Projects | 474 | 16 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 1534 | 31 |
47 | 1 | 7/8/2000 12:00:00 AM | 453054409 | DMB | DMB | 3 | 13 |
47 | 2 | 3/9/1999 12:00:00 AM | 453054608 | Dave solo | Dave Side Projects | 490 | 62 |
47 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | Dave Side Projects | 474 | 16 |
47 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 1534 | 31 |
56 | 1 | 7/9/2000 12:00:00 AM | 453054410 | DMB | DMB | 2 | 13 |
56 | 3 | 1/23/1999 12:00:00 AM | 453054576 | Dave & Tim | Dave Side Projects | 535 | 16 |
57 | 1 | 7/9/2000 12:00:00 AM | 453054410 | DMB | DMB | 2 | 13 |
57 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | Dave Side Projects | 474 | 16 |
59 | 1 | 7/9/2000 12:00:00 AM | 453054410 | DMB | DMB | 2 | 13 |
59 | 3 | 3/13/1999 12:00:00 AM | 453054612 | Dave & Tim | Dave Side Projects | 486 | 16 |
63 | 1 | 7/8/2000 12:00:00 AM | 453054409 | DMB | DMB | 3 | 13 |
65 | 2 | 7/15/1999 12:00:00 AM | 453055889 | Dave solo | Dave Side Projects | 362 | 62 |
65 | 3 | 3/25/1999 12:00:00 AM | 453054615 | Dave & Tim | Dave Side Projects | 474 | 16 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | Dave Side Projects | 142 | 15 |
70 | 1 | 7/8/2000 12:00:00 AM | 453054409 | DMB | DMB | 3 | 13 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
2 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 3407 | 65 |
2 | 2 | 5/2/1992 12:00:00 AM | 453055635 | Dave solo | Dave Side Projects | 2992 | 57 |
2 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 2637 | 53 |
9 | 1 | 3/14/1991 12:00:00 AM | 453056860 | DMB | DMB | 3407 | 65 |
9 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 2860 | 57 |
9 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 2637 | 53 |
10 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 3237 | 65 |
10 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 1549 | 31 |
10 | 3 | 8/25/1994 12:00:00 AM | 453055361 | Dave & Tim | Dave Side Projects | 2147 | 52 |
10 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | DMB | 1789 | 41 |
12 | 1 | 8/31/1991 12:00:00 AM | 453056808 | DMB | DMB | 3237 | 65 |
12 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 2860 | 57 |
12 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 2637 | 53 |
21 | 1 | 2/13/1992 12:00:00 AM | 453055738 | DMB | DMB | 3071 | 56 |
21 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 2860 | 57 |
21 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 2637 | 53 |
22 | 1 | 3/1/1992 12:00:00 AM | 453055741 | DMB | DMB | 3054 | 56 |
22 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | Dave Side Projects | 2860 | 57 |
22 | 3 | 4/22/1993 12:00:00 AM | 453055550 | Dave & Tim | Dave Side Projects | 2637 | 53 |
22 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | DMB | 2650 | 53 |
22 | 15 | 3/10/1994 12:00:00 AM | 453089625 | Dave & Boyd | DMB | 2315 | 52 |
36 | 1 | 4/14/1993 12:00:00 AM | 453055545 | DMB | DMB | 2645 | 51 |
36 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 1549 | 31 |
36 | 3 | 11/7/1994 12:00:00 AM | 453055306 | Dave & Tim | Dave Side Projects | 2073 | 52 |
37 | 1 | 10/15/1993 12:00:00 AM | 453055455 | DMB | DMB | 2461 | 51 |
37 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 1549 | 31 |
37 | 3 | 12/12/1993 12:00:00 AM | 453055494 | Dave & Tim | Dave Side Projects | 2403 | 53 |
37 | 14 | 12/15/1994 12:00:00 AM | 453055332 | Dave, Boyd & Stefan | DMB | 2035 | 52 |
41 | 1 | 4/7/1995 12:00:00 AM | 453055187 | DMB | DMB | 1922 | 37 |
41 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | Dave Side Projects | 1549 | 31 |
41 | 3 | 2/1/1996 12:00:00 AM | 453054992 | Dave & Tim | Dave Side Projects | 1622 | 27 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 1534 | 31 |
47 | 1 | 10/4/1995 12:00:00 AM | 453055261 | DMB | DMB | 1742 | 41 |
47 | 2 | 3/8/1999 12:00:00 AM | 453054607 | Dave solo | Dave Side Projects | 491 | 62 |
47 | 3 | 12/16/1996 12:00:00 AM | 453055128 | Dave & Tim | Dave Side Projects | 1303 | 31 |
47 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | DMB | 1534 | 31 |
56 | 1 | 11/29/1994 12:00:00 AM | 453055320 | DMB | DMB | 2051 | 45 |
56 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 539 | 16 |
57 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 815 | 23 |
57 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 539 | 16 |
59 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 815 | 23 |
59 | 3 | 1/26/1999 12:00:00 AM | 453054578 | Dave & Tim | Dave Side Projects | 532 | 16 |
63 | 1 | 6/20/2000 12:00:00 AM | 453054399 | DMB | DMB | 21 | 13 |
65 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 22 | 13 |
65 | 2 | 3/8/1999 12:00:00 AM | 453056428 | Dave solo | Dave Side Projects | 491 | 62 |
65 | 3 | 1/29/1999 12:00:00 AM | 453054581 | Dave & Tim | Dave Side Projects | 529 | 16 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | Dave Side Projects | 142 | 15 |
70 | 1 | 6/27/2000 12:00:00 AM | 453054404 | DMB | DMB | 14 | 13 |
73 | 1 | 7/3/2000 12:00:00 AM | 453054407 | DMB | DMB | 8 | 13 |
75 | 1 | 6/19/2000 12:00:00 AM | 453054398 | DMB | DMB | 22 | 13 |
92 | 1 | 10/3/1996 12:00:00 AM | 453055078 | DMB | DMB | 1377 | 29 |
93 | 1 | 8/1/1998 12:00:00 AM | 453054734 | DMB | DMB | 710 | 21 |