# Pastebin gx78LzSv SELECT mm.recording_mbid , artist_mbids FROM listen l JOIN mbid_mapping mm ON mm.recording_msid::TEXT = l.data->'track_metadata'->'additional_info'->>'recording_msid' JOIN mb_metadata_cache mbc ON mbc.recording_mbid = mm.recording_mbid