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 = 453089770 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 < '9/30/2020' OR (SongInfo.ShowDate = '9/30/2020' AND SongInfo.ShowID < 453089770)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
220 | 1 | 10/20/2019 12:00:00 AM | 453089613 | DMB | DMB | 346 | 6158 |
220 | 2 | 5/28/2020 12:00:00 AM | 453089738 | Dave solo | Dave Side Projects | 125 | 8166 |
220 | 3 | 2/14/2020 12:00:00 AM | 453089607 | Dave & Tim | Dave Side Projects | 229 | 8162 |
220 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 5352 | 86 |
236 | 1 | 9/2/2016 12:00:00 AM | 453065436 | DMB | DMB | 1489 | 2154 |
236 | 2 | 9/11/2019 12:00:00 AM | 453089611 | Dave solo | Dave Side Projects | 385 | 6158 |
236 | 3 | 2/14/2020 12:00:00 AM | 453089607 | Dave & Tim | Dave Side Projects | 229 | 8162 |
236 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | Dave Side Projects | 5352 | 86 |
236 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 1417 | 1154 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
220 | 1 | 8/10/2008 12:00:00 AM | 453056567 | DMB | DMB | 4434 | 98 |
220 | 2 | 1/9/2004 12:00:00 AM | 453056065 | Dave solo | Dave Side Projects | 6109 | 79 |
220 | 3 | 3/26/2003 12:00:00 AM | 453055955 | Dave & Tim | Dave Side Projects | 6398 | 70 |
220 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 6137 | 76 |
236 | 1 | 6/1/2013 12:00:00 AM | 453057090 | DMB | DMB | 2678 | 120 |
236 | 2 | 1/9/2004 12:00:00 AM | 453056065 | Dave solo | Dave Side Projects | 6109 | 79 |
236 | 3 | 10/28/2005 12:00:00 AM | 453056235 | Dave & Tim | Dave Side Projects | 5451 | 84 |
236 | 4 | 12/12/2003 12:00:00 AM | 453056045 | Dave & Friends | Dave Side Projects | 6137 | 76 |
236 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | Dave Side Projects | 1417 | 1154 |