# Pastebin byKDd15R listenbrainz_ts=> select recording_data->>'name' as recording_name, total_listen_count from popularity.recording pr join mapping.mb_metadata_cache mbc on mbc.recording_mbid = pr.recording_mbid order by total_listen_count desc limit 10; recording_name | total_listen_count -------------------------+-------------------- Kids | 3920669 Rolling in the Deep | 3905454 Supermassive Black Hole | 3868784 Viva la vida | 3857293 Mr. Brightside | 3751168 Smells Like Teen Spirit | 3726295 Karma Police | 3650725 Wonderwall | 3626044 Crystalised | 3529463 Starlight | 3485413 (10 rows) listenbrainz_ts=> select recording_data->>'name' as recording_name, total_user_count from popularity.recording pr join mapping.mb_metadata_cache mbc on mbc.recording_mbid = pr.recording_mbid order by total_user_count desc limit 10; recording_name | total_user_count -------------------------+------------------ Smells Like Teen Spirit | 298990 Come as You Are | 276134 Karma Police | 266661 Kids | 256284 Wonderwall | 247298 Paranoid Android | 246335 Lithium | 243346 Mr. Brightside | 240279 Californication | 232902 Viva la vida | 232874 (10 rows)