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 = 453089600 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '6/17/2019' OR (SongInfo.ShowDate = '6/17/2019' AND SongInfo.ShowID < 453089600)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
17 | 1 | 6/14/2019 12:00:00 AM | 453086583 | DMB | 3 | 7160 |
17 | 2 | 9/19/2018 12:00:00 AM | 453083559 | Dave solo | 271 | 5156 |
17 | 3 | 4/20/2019 12:00:00 AM | 453089573 | Dave & Tim | 58 | 6158 |
17 | 4 | 12/19/2003 12:00:00 AM | 453056050 | Dave & Friends | 5659 | 76 |
17 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | 946 | 1154 |
17 | 3058 | 11/1/2016 12:00:00 AM | 453068422 | Joshua Bell | 958 | 1154 |
49 | 1 | 6/14/2019 12:00:00 AM | 453086583 | DMB | 3 | 7160 |
49 | 2 | 6/12/2019 12:00:00 AM | 453089602 | Dave solo | 5 | 6158 |
49 | 3 | 4/20/2019 12:00:00 AM | 453089573 | Dave & Tim | 58 | 6158 |
49 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | 5665 | 76 |
49 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | 946 | 1154 |
55 | 1 | 6/15/2019 12:00:00 AM | 453086584 | DMB | 2 | 7160 |
55 | 2 | 4/20/2018 12:00:00 AM | 453079538 | Dave solo | 423 | 5156 |
55 | 3 | 4/20/2019 12:00:00 AM | 453089573 | Dave & Tim | 58 | 6158 |
55 | 4 | 11/13/2004 12:00:00 AM | 453056220 | Dave & Friends | 5329 | 79 |
55 | 1024 | 9/4/2014 12:00:00 AM | 453057206 | Dave, Tim & Rashawn | 1747 | 122 |
55 | 7057 | 12/10/2017 12:00:00 AM | 453078475 | Stevie Wonder | 554 | 5155 |
70 | 1 | 5/18/2019 12:00:00 AM | 453086581 | DMB | 30 | 7160 |
70 | 2 | 9/19/2018 12:00:00 AM | 453083559 | Dave solo | 271 | 5156 |
70 | 3 | 4/20/2019 12:00:00 AM | 453089573 | Dave & Tim | 58 | 6158 |
70 | 4 | 1/16/2004 12:00:00 AM | 453056056 | Dave & Friends | 5631 | 77 |
70 | 1024 | 9/4/2014 12:00:00 AM | 453057206 | Dave, Tim & Rashawn | 1747 | 122 |
75 | 1 | 6/14/2019 12:00:00 AM | 453086583 | DMB | 3 | 7160 |
75 | 2 | 10/27/2018 12:00:00 AM | 453083591 | Dave solo | 233 | 5156 |
75 | 3 | 4/20/2019 12:00:00 AM | 453089573 | Dave & Tim | 58 | 6158 |
95 | 1 | 7/25/2010 12:00:00 AM | 453056755 | DMB | 3249 | 110 |
95 | 2 | 2/6/2019 12:00:00 AM | 453087576 | Dave solo | 131 | 6158 |
95 | 3 | 2/15/2019 12:00:00 AM | 453083555 | Dave & Tim | 122 | 6158 |
236 | 1 | 9/2/2016 12:00:00 AM | 453065436 | DMB | 1018 | 2154 |
236 | 2 | 9/24/2011 12:00:00 AM | 453056962 | Dave solo | 2823 | 114 |
236 | 3 | 2/15/2019 12:00:00 AM | 453083555 | Dave & Tim | 122 | 6158 |
236 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | 4881 | 86 |
236 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | 946 | 1154 |
586 | 1 | 6/15/2019 12:00:00 AM | 453086584 | DMB | 2 | 7160 |
586 | 2 | 10/2/2017 12:00:00 AM | 453076475 | Dave solo | 623 | 3154 |
586 | 3 | 4/20/2019 12:00:00 AM | 453089573 | Dave & Tim | 58 | 6158 |
588 | 1 | 10/18/2015 12:00:00 AM | 453061212 | DMB | 1338 | 1129 |
588 | 2 | 10/27/2018 12:00:00 AM | 453083591 | Dave solo | 233 | 5156 |
588 | 3 | 2/16/2019 12:00:00 AM | 453083554 | Dave & Tim | 121 | 6158 |
588 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | 946 | 1154 |
730 | 1 | 7/22/2014 12:00:00 AM | 453057180 | DMB | 1791 | 125 |
730 | 3 | 1/16/2014 12:00:00 AM | 453057149 | Dave & Tim | 1978 | 122 |
15937 | 1 | 6/14/2019 12:00:00 AM | 453086583 | DMB | 3 | 7160 |
15937 | 2 | 10/27/2018 12:00:00 AM | 453083591 | Dave solo | 233 | 5156 |
15937 | 3 | 4/20/2019 12:00:00 AM | 453089573 | Dave & Tim | 58 | 6158 |
16948 | 1 | 9/8/2018 12:00:00 AM | 453079520 | DMB | 282 | 6156 |
16948 | 2 | 9/19/2018 12:00:00 AM | 453083559 | Dave solo | 271 | 5156 |
16948 | 3 | 4/20/2019 12:00:00 AM | 453089573 | Dave & Tim | 58 | 6158 |