# Pastebin FLNpIDzA
WITH release_mbids AS MATERIALIZED (
                                         SELECT rl.gid AS release_mbid
                                              , rg.gid AS release_group_mbid
                                              , r.gid AS recording_mbid
                                              , rl.name AS release_name
                                           FROM release rl
                                           JOIN medium m
                                             ON m.release = rl.id
                                           JOIN track t
                                             ON t.medium = m.id
                                           JOIN recording r
                                             ON t.recording = r.id
                                           JOIN release_group rg
                                             ON rl.release_group = rg.id
                                          WHERE r.gid IN ('4261a8f7-e614-4e71-aff3-12628be03817')
                                )
                                         SELECT rid.recording_mbid AS src_recording_mbid
                                              , rid.release_mbid AS release_mbid
                                              , rid.release_group_mbid AS release_group_mbid
                                              , rid.release_name AS release_name
                                              , r.gid AS recording_mbid
                                              , r.name AS recording_name
                                              , r.length AS duration
                                              , t.position
                                              , m.position as medium_position
                                           FROM recording r
                                           JOIN track t
                                             ON t.recording = r.id
                                           JOIN medium m
                                             ON t.medium = m.id
                                           JOIN release rl
                                             ON m.release = rl.id
                                           JOIN release_mbids rid
                                             ON rl.gid = rid.release_mbid
;