SELECT SongInfo.SongID, SongInfo.ShowDate, SongInfo.ShowID, ShowInfo.ArtistID, 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 = 453065422 INNER JOIN ShowInfo ON ShowInfo.ShowID = SongInfo.ShowID INNER JOIN ShowArtists ON ShowArtists.ArtistID = ShowInfo.ArtistID WHERE (SongInfo.ShowDate < '7/15/2016' OR (SongInfo.ShowDate = '7/15/2016' AND SongInfo.ShowID < 453065422)) AND (SongInfo.SongRole IS NULL OR SongInfo.SongRole = '') ORDER BY SongInfo.ShowDate DESC, SongInfo.SongID DESCtable record count =9804
hash count=22