SELECT DISTINCT SongInfo.SongID, SongInfo.ShowDate, SongInfo.ShowID, DATEDIFF (D, SongInfo.ShowDate, ThisShow.ShowDate) NumDays, ShowInfo.TourID FROM SongInfo INNER JOIN SongInfo ThisShow ON ThisShow.SongID = SongInfo.SongID AND ThisShow.ShowID = 453058208 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID WHERE (SongInfo.ShowDate < '1/17/2015' OR (SongInfo.ShowDate = '1/17/2015' AND SongInfo.ShowID < 453058208)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') AND (ShowInfo.ArtistID = 3) ORDER BY SongInfo.ShowDate DESC, SongInfo.SongID DESC