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 = 453056927 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID WHERE (SongInfo.ShowDate < '6/25/2011' OR (SongInfo.ShowDate = '6/25/2011' AND SongInfo.ShowID < 453056927)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') AND (ShowInfo.ArtistID = 3) ORDER BY SongInfo.ShowDate DESC, SongInfo.SongID DESC