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 = 453075454 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 < '10/3/2017' OR (SongInfo.ShowDate = '10/3/2017' AND SongInfo.ShowID < 453075454)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
AVERAGE QUERY TIME: 200.2773
TOTAL ITERATIONS: 1
DMBAlmanac.com
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
49 | 1 | 9/24/2017 12:00:00 AM | 453075474 | DMB | DMB | 9 | 3154 |
49 | 2 | 10/12/2016 12:00:00 AM | 453069410 | Dave solo | Dave Side Projects | 356 | 1154 |
49 | 3 | 9/16/2017 12:00:00 AM | 453072474 | Dave & Tim | Dave Side Projects | 17 | 3154 |
49 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 5043 | 76 |
49 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 324 | 1154 |
111 | 1 | 6/3/2015 12:00:00 AM | 453060215 | DMB | DMB | 853 | 128 |
111 | 2 | 2/26/2001 12:00:00 AM | 453056339 | Dave solo | Dave Side Projects | 6063 | 1 |
111 | 51 | 10/14/2001 12:00:00 AM | 453063294 | Emmylou Harris | Openers and Collaborators | 5833 | 1140 |
111 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | Dave Side Projects | 5079 | 75 |
588 | 1 | 10/18/2015 12:00:00 AM | 453061212 | DMB | DMB | 716 | 1129 |
588 | 2 | 8/22/2010 12:00:00 AM | 453056830 | Dave solo | Dave Side Projects | 2599 | 109 |
588 | 3 | 6/11/2017 12:00:00 AM | 453071420 | Dave & Tim | Dave Side Projects | 114 | 5154 |
588 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 324 | 1154 |
693 | 1 | 9/13/2015 12:00:00 AM | 453060252 | DMB | DMB | 751 | 128 |
693 | 2 | 4/3/2014 12:00:00 AM | 453057198 | Dave solo | Dave Side Projects | 1279 | 122 |
693 | 3 | 11/19/2011 12:00:00 AM | 453056966 | Dave & Tim | Dave Side Projects | 2145 | 114 |
723 | 1 | 9/24/2017 12:00:00 AM | 453075474 | DMB | DMB | 9 | 3154 |
723 | 2 | 9/12/2017 12:00:00 AM | 453075475 | Dave solo | Dave Side Projects | 21 | 3154 |
723 | 3 | 9/16/2017 12:00:00 AM | 453072474 | Dave & Tim | Dave Side Projects | 17 | 3154 |
723 | 87 | 10/10/2014 12:00:00 AM | 453057207 | Hugh Masekela & Vusi Mahlasela | Openers and Collaborators | 1089 | 1130 |
723 | 1024 | 9/4/2014 12:00:00 AM | 453057206 | Dave, Tim & Rashawn | DMB | 1125 | 122 |
4873 | 1 | 9/3/2016 12:00:00 AM | 453065437 | DMB | DMB | 395 | 2154 |
4873 | 2 | 11/12/2016 12:00:00 AM | 453068411 | Dave solo | Dave Side Projects | 325 | 1154 |
4873 | 3 | 6/18/2017 12:00:00 AM | 453071425 | Dave & Tim | Dave Side Projects | 107 | 5154 |
4873 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 324 | 1154 |
4873 | 3058 | 11/1/2016 12:00:00 AM | 453068422 | Joshua Bell | Openers and Collaborators | 336 | 1154 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
49 | 1 | 4/18/1998 12:00:00 AM | 453054683 | DMB | DMB | 7108 | 23 |
49 | 2 | 7/1/1998 12:00:00 AM | 453056508 | Dave solo | Dave Side Projects | 7034 | 23 |
49 | 3 | 1/19/1999 12:00:00 AM | 453054573 | Dave & Tim | Dave Side Projects | 6832 | 16 |
49 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | Dave Side Projects | 5043 | 76 |
49 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 324 | 1154 |
111 | 1 | 6/3/2015 12:00:00 AM | 453060215 | DMB | DMB | 853 | 128 |
111 | 2 | 2/26/2001 12:00:00 AM | 453056339 | Dave solo | Dave Side Projects | 6063 | 1 |
111 | 51 | 10/14/2001 12:00:00 AM | 453063294 | Emmylou Harris | Openers and Collaborators | 5833 | 1140 |
111 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | Dave Side Projects | 5079 | 75 |
588 | 1 | 6/25/2010 12:00:00 AM | 453056774 | DMB | DMB | 2657 | 110 |
588 | 2 | 8/22/2010 12:00:00 AM | 453056830 | Dave solo | Dave Side Projects | 2599 | 109 |
588 | 3 | 12/10/2009 12:00:00 AM | 453056729 | Dave & Tim | Dave Side Projects | 2854 | 104 |
588 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 324 | 1154 |
693 | 1 | 7/8/2011 12:00:00 AM | 453056922 | DMB | DMB | 2279 | 115 |
693 | 2 | 10/14/2011 12:00:00 AM | 453056963 | Dave solo | Dave Side Projects | 2181 | 114 |
693 | 3 | 8/20/2011 12:00:00 AM | 453056946 | Dave & Tim | Dave Side Projects | 2236 | 114 |
723 | 1 | 5/18/2012 12:00:00 AM | 453056974 | DMB | DMB | 1964 | 117 |
723 | 2 | 4/24/2012 12:00:00 AM | 453057017 | Dave solo | Dave Side Projects | 1988 | 116 |
723 | 3 | 7/15/2012 12:00:00 AM | 453057034 | Dave & Tim | Dave Side Projects | 1906 | 116 |
723 | 87 | 10/10/2014 12:00:00 AM | 453057207 | Hugh Masekela & Vusi Mahlasela | Openers and Collaborators | 1089 | 1130 |
723 | 1024 | 9/4/2014 12:00:00 AM | 453057206 | Dave, Tim & Rashawn | DMB | 1125 | 122 |
4873 | 1 | 5/7/2016 12:00:00 AM | 453067393 | DMB | DMB | 514 | 2154 |
4873 | 2 | 6/6/2016 12:00:00 AM | 453067401 | Dave solo | Dave Side Projects | 484 | 1154 |
4873 | 3 | 7/6/2016 12:00:00 AM | 453067395 | Dave & Tim | Dave Side Projects | 454 | 1154 |
4873 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 324 | 1154 |
4873 | 3058 | 11/1/2016 12:00:00 AM | 453068422 | Joshua Bell | Openers and Collaborators | 336 | 1154 |