{"body":"    WITH mbid_similarity AS (\n        SELECT recording_mbid AS mbid_0\n             , LEAD(recording_mbid, 1) OVER row_next AS mbid_1\n             , (artist_credit_id != LEAD(artist_credit_id, 1) OVER row_next AND recording_mbid != LEAD(recording_mbid, 1) OVER row_next) AS similar\n          FROM listen\n         WHERE recording_mbid IS NOT NULL \n        WINDOW row_next AS (PARTITION BY user_name ORDER BY listened_at)\n    )\n    SELECT mbid_0\n         , mbid_1\n         , SUM(CASE WHEN similar THEN 1 ELSE 0 END) AS similarity\n      FROM mbid_similarity\n     WHERE mbid_0 IS NOT NULL\n       AND mbid_1 IS NOT NULL\n  GROUP BY mbid_0, mbid_1","name":"","extension":"txt","url":"https://www.irccloud.com/pastebin/xkpGcisP","modified":1643470137,"id":"xkpGcisP","size":639,"lines":15,"own_paste":false,"theme":"","date":1643470137}