SELECT SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate, SongInfo.ShowID, ShowArtists.ShortName, DATEDIFF (D, SongInfo.ShowDate, ThisShow.ShowDate) NumDays, ShowInfo.TourID FROM SongInfo INNER JOIN SongInfo ThisShow ON ThisShow.SongID = SongInfo.SongID AND ThisShow.ShowID = 453075455 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '10/4/2017' OR (SongInfo.ShowDate = '10/4/2017' AND SongInfo.ShowID < 453075455)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
65 | 1 | 9/3/2016 12:00:00 AM | 453065437 | DMB | 396 | 2154 |
65 | 2 | 4/13/2011 12:00:00 AM | 453056930 | Dave solo | 2366 | 114 |
65 | 3 | 6/17/2017 12:00:00 AM | 453071424 | Dave & Tim | 109 | 5154 |
65 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | 4260 | 86 |
65 | 21 | 2/20/2000 12:00:00 AM | 453055865 | Dave & Emmylou Harris | 6436 | 15 |
98 | 1 | 9/6/2015 12:00:00 AM | 453060248 | DMB | 759 | 128 |
98 | 2 | 4/14/1996 12:00:00 AM | 453055124 | Dave solo | 7843 | 31 |
98 | 3 | 12/11/2009 12:00:00 AM | 453056730 | Dave & Tim | 2854 | 104 |
98 | 12 | 7/3/1993 12:00:00 AM | 453089752 | C-ville Allstars | 8859 | 53 |
98 | 15 | 3/10/1994 12:00:00 AM | 453089625 | Dave & Boyd | 8609 | 52 |
98 | 79 | 7/11/2012 12:00:00 AM | 453068417 | Brandi Carlile | 1911 | 1150 |
98 | 10141 | 5/4/1993 12:00:00 AM | 453079541 | Boyd & Co. | 8919 | 1132 |
111 | 1 | 6/3/2015 12:00:00 AM | 453060215 | DMB | 854 | 128 |
111 | 2 | 10/3/2017 12:00:00 AM | 453075454 | Dave solo | 1 | 3154 |
111 | 51 | 10/14/2001 12:00:00 AM | 453063294 | Emmylou Harris | 5834 | 1140 |
111 | 10128 | 11/7/2003 12:00:00 AM | 453056043 | Dave and Friends & Emmylou Harris | 5080 | 75 |
304 | 1 | 9/3/2016 12:00:00 AM | 453065437 | DMB | 396 | 2154 |
304 | 2 | 4/8/2011 12:00:00 AM | 453056929 | Dave solo | 2371 | 114 |
304 | 3 | 5/7/2017 12:00:00 AM | 453071412 | Dave & Tim | 150 | 5154 |
723 | 1 | 9/24/2017 12:00:00 AM | 453075474 | DMB | 10 | 3154 |
723 | 2 | 10/3/2017 12:00:00 AM | 453075454 | Dave solo | 1 | 3154 |
723 | 3 | 9/16/2017 12:00:00 AM | 453072474 | Dave & Tim | 18 | 3154 |
723 | 87 | 10/10/2014 12:00:00 AM | 453057207 | Hugh Masekela & Vusi Mahlasela | 1090 | 1130 |
723 | 1024 | 9/4/2014 12:00:00 AM | 453057206 | Dave, Tim & Rashawn | 1126 | 122 |
4873 | 1 | 9/3/2016 12:00:00 AM | 453065437 | DMB | 396 | 2154 |
4873 | 2 | 10/3/2017 12:00:00 AM | 453075454 | Dave solo | 1 | 3154 |
4873 | 3 | 6/18/2017 12:00:00 AM | 453071425 | Dave & Tim | 108 | 5154 |
4873 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | 325 | 1154 |
4873 | 3058 | 11/1/2016 12:00:00 AM | 453068422 | Joshua Bell | 337 | 1154 |
15939 | 2 | 10/3/2017 12:00:00 AM | 453075454 | Dave solo | 1 | 3154 |