# Pastebin oMhK1dkL
WITH exclude_tracks AS (
                            SELECT recording_mbid
                              FROM mapping.tracks_of_the_year t
                             WHERE user_name = %s
                        ) SELECT q.recording_mbid
                               , r.name AS recording_name
                               , ac.name AS artist_credit_name
                               , sum(listen_count) AS listen_count
                              FROM mapping.tracks_of_the_year t
                             WHERE user_name IN (%s, %s, %s)
                               AND recording_mbid NOT IN (SELECT * FROM exclude_tracks)
                       GROUP BY q.recording_mbid, r.name, ac.name
                       ORDER BY listen_count DESC
                          LIMIT 100