# Pastebin KYenQRqV WITH exclude_tracks AS ( SELECT recording_mbid FROM mapping.tracks_of_the_year t WHERE user_name = %s ) SELECT recording_mbid , recording_name , 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 recording_mbid, recording_name, artist_credit_name ORDER BY listen_count DESC LIMIT 100