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 = 453079512 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID WHERE (SongInfo.ShowDate < '7/28/2018' OR (SongInfo.ShowDate = '7/28/2018' AND SongInfo.ShowID < 453079512)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') AND (ShowInfo.ArtistID = 1) ORDER BY SongInfo.ShowDate DESC, SongInfo.SongID DESC