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 = 453089630 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '1/25/2020' OR (SongInfo.ShowDate = '1/25/2020' AND SongInfo.ShowID < 453089630)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.SongID, ShowInfo.ArtistID, SongInfo.ShowDate DESC
SongID | ArtistID | ShowDate | ShowID | ShortName | NumDays | TourID |
41 | 1 | 10/18/2019 12:00:00 AM | 453089612 | DMB | 99 | 6158 |
41 | 2 | 4/20/2018 12:00:00 AM | 453079538 | Dave solo | 645 | 5156 |
41 | 3 | 6/18/2019 12:00:00 AM | 453089574 | Dave & Tim | 221 | 6158 |
41 | 4 | 2/4/2006 12:00:00 AM | 453056258 | Dave & Friends | 5103 | 86 |
41 | 8 | 3/13/2011 12:00:00 AM | 453056925 | Secret Stash | 3240 | 114 |
41 | 14 | 4/29/1996 12:00:00 AM | 453055126 | Dave, Boyd & Stefan | 8671 | 31 |
41 | 3055 | 11/13/2016 12:00:00 AM | 453068410 | Dave & Carlos Varela | 1168 | 1154 |
127 | 1 | 9/1/2019 12:00:00 AM | 453086610 | DMB | 146 | 7160 |
127 | 2 | 9/11/1992 12:00:00 AM | 453055702 | Dave solo | 9997 | 57 |
127 | 3 | 2/17/2019 12:00:00 AM | 453083556 | Dave & Tim | 342 | 6158 |
127 | 4 | 12/13/2003 12:00:00 AM | 453056046 | Dave & Friends | 5887 | 76 |
127 | 6 | 4/15/2017 12:00:00 AM | 453071451 | 123 Go! | 1015 | 3154 |
127 | 7 | 3/16/2013 12:00:00 AM | 453057075 | Yukon Kornelius | 2506 | 119 |
127 | 12 | 1/12/1993 12:00:00 AM | 453055495 | C-ville Allstars | 9874 | 53 |
127 | 20 | 5/6/2001 12:00:00 AM | 453056944 | Jazzfest Superjam | 6838 | 1 |
127 | 26 | 1/16/1994 12:00:00 AM | 453063247 | The Samples | 9505 | 1133 |
127 | 31 | 10/15/1994 12:00:00 AM | 453063256 | Phish | 9233 | 1133 |
127 | 85 | 2/26/2016 12:00:00 AM | 453066392 | Phil & Friends | 1429 | 2155 |
127 | 2045 | 8/3/2012 12:00:00 AM | 453057047 | Boyd & Tucker Rogers | 2731 | 116 |
127 | 2051 | 10/13/2017 12:00:00 AM | 453075469 | Crystal Garden | 834 | 5155 |
127 | 9116 | 8/18/1995 12:00:00 AM | 453089621 | Dave, Roi & Stefan | 8926 | 41 |
666 | 6 | 4/15/2017 12:00:00 AM | 453071451 | 123 Go! | 1015 | 3154 |
666 | 7 | 12/10/2011 12:00:00 AM | 453056970 | Yukon Kornelius | 2968 | 114 |
666 | 8 | 3/13/2011 12:00:00 AM | 453056925 | Secret Stash | 3240 | 114 |
673 | 6 | 4/15/2017 12:00:00 AM | 453071451 | 123 Go! | 1015 | 3154 |
673 | 8 | 3/13/2011 12:00:00 AM | 453056925 | Secret Stash | 3240 | 114 |
717 | 7 | 3/16/2013 12:00:00 AM | 453057075 | Yukon Kornelius | 2506 | 119 |
717 | 2039 | 3/1/2013 12:00:00 AM | 453063377 | Brooks Young Band | 2521 | 1151 |
718 | 7 | 3/16/2013 12:00:00 AM | 453057075 | Yukon Kornelius | 2506 | 119 |
748 | 6 | 4/15/2017 12:00:00 AM | 453071451 | 123 Go! | 1015 | 3154 |
748 | 7 | 3/16/2013 12:00:00 AM | 453057075 | Yukon Kornelius | 2506 | 119 |
3844 | 62 | 1/30/2014 12:00:00 AM | 453064385 | O.A.R. | 2186 | 1130 |
17003 | 1025 | 10/6/2018 12:00:00 AM | 453083560 | Chad Smith's SMFJRA | 476 | 5156 |
21992 | 85 | 8/13/2016 12:00:00 AM | 453067411 | Phil & Friends | 1260 | 2155 |