- join: carveouts_release_level_carveouts
    sql_on: ${_X_.upc} = ${carveouts_release_level_carveouts.upc}
    relationship: one_to_many
    fields: [sets.manual_release_carveout_fields*]

  - join: bi_artists_blacklisted_by_itunes
    sql_on: _X_.artist_id = bi_artists_blacklisted_by_itunes.artist_id
    relationship: one_to_one
    fields: [is_blacklisted_by_itunes]

  - join: bi_artist_name_cleaned
    sql_on: _X_.artist_id = bi_artist_name_cleaned.artist_id
    relationship: one_to_one
    fields: [artist_name_cleaned, artist_name_cleaned_nows]

  - join: bi_country_view
    sql_on: ${_X_.country_code} = ${bi_country_view.country_code}
    relationship: many_to_one
    fields: [sets.manual_territory_fields*]

  - join: bi_artist_view
    sql_on: ${_X_.artist_id} = ${bi_artist_view.artist_id}
    relationship: many_to_one
    fields: [sets.manual_artist_view_fields*]

  - join: bi_label_view
    sql_on: ${_X_.label_id} = ${bi_label_view.label_id}
    relationship: many_to_one
    fields: [sets.manual_label_view_fields*]

  - join: bi_release_with_metadata_view
    sql_on: ${_X_.upc} = ${bi_release_with_metadata_view.upc}
    relationship: many_to_one
    fields: [sets.manual_release_view_fields*]