# Pastebin xzrnSgSb
Redirect Table
"""
    select r.gid AS new, 
    rgr.gid AS old 
    from recording r 
    join recording_gid_redirect rgr 
    on rgr.new_id = r.id"""

Canonical Table:
"""
    select recording_mbid as old, 
    canonical_recording_mbid as new 
    from mapping.canonical_recording_redirect"""