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 = 453089624 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 < '11/24/2019' OR (SongInfo.ShowDate = '11/24/2019' AND SongInfo.ShowID < 453089624)) 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 |
168 | 1 | 8/30/2008 12:00:00 AM | 453056575 | DMB | DMB | 4103 | 98 |
628 | 2 | 1/21/2014 12:00:00 AM | 453057197 | Dave solo | Dave Side Projects | 2133 | 122 |
628 | 3 | 12/7/2010 12:00:00 AM | 453056863 | Dave & Tim | Dave Side Projects | 3274 | 113 |
694 | 1 | 8/26/2011 12:00:00 AM | 453056939 | DMB | DMB | 3012 | 115 |
SongID | ArtistID | ShowDate | ShowID | ShortName | CategoryName | NumDays | TourID |
168 | 1 | 6/3/2008 12:00:00 AM | 453056542 | DMB | DMB | 4191 | 98 |
628 | 1 | 5/29/2010 12:00:00 AM | 453056761 | DMB | DMB | 3466 | 110 |
628 | 2 | 1/29/2010 12:00:00 AM | 453056753 | Dave solo | Dave Side Projects | 3586 | 109 |
628 | 3 | 5/20/2010 12:00:00 AM | 453056756 | Dave & Tim | Dave Side Projects | 3475 | 109 |
694 | 1 | 8/26/2011 12:00:00 AM | 453056939 | DMB | DMB | 3012 | 115 |