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 = 453091043 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '7/3/2023' OR (SongInfo.ShowDate = '7/3/2023' AND SongInfo.ShowID < 453091043)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
96 | 1 | 6/30/2023 12:00:00 AM | 453091003 | DMB | 3 | 8174 |
96 | 2 | 1/28/2023 12:00:00 AM | 453091030 | Dave solo | 156 | 8171 |
96 | 3 | 2/17/2023 12:00:00 AM | 453090931 | Dave & Tim | 136 | 8171 |
96 | 13 | 4/9/1993 12:00:00 AM | 453055542 | Dave & Carter | 11042 | 53 |
96 | 23 | 2/5/1993 12:00:00 AM | 453055506 | Ritz Power Jam | 11105 | 1132 |
96 | 31 | 4/21/1994 12:00:00 AM | 453063250 | Phish | 10665 | 1133 |
96 | 45 | 4/30/2005 12:00:00 AM | 453086573 | Gov't Mule | 6638 | 1144 |
96 | 63 | 6/30/2004 12:00:00 AM | 453063318 | Keller Williams | 6942 | 1143 |
96 | 80 | 8/20/2011 12:00:00 AM | 453063351 | Warren Haynes Band | 4335 | 1149 |
96 | 85 | 2/26/2016 12:00:00 AM | 453066392 | Phil & Friends | 2684 | 2155 |
405 | 56 | 6/21/2003 12:00:00 AM | 453063309 | moe. | 7317 | 1142 |
405 | 80 | 8/20/2011 12:00:00 AM | 453063351 | Warren Haynes Band | 4335 | 1149 |
405 | 85 | 8/13/2016 12:00:00 AM | 453067411 | Phil & Friends | 2515 | 2155 |
405 | 2045 | 8/3/2012 12:00:00 AM | 453064383 | Boyd & Tucker Rogers | 3986 | 116 |
4894 | 2 | 1/28/2023 12:00:00 AM | 453091030 | Dave solo | 156 | 8171 |
4894 | 85 | 2/26/2016 12:00:00 AM | 453066392 | Phil & Friends | 2684 | 2155 |