view: track_artist_derived_table {
  derived_table: {
    sql: select t2.isrc, t2.upc, GROUP_CONCAT(ta2.NAME) as key3
      from art_relations.track t2
      inner join art_relations.releases r2 on t2.upc=r2.upc
      inner join art_relations.track_artist ta2 on t2.id=ta2.track_id
      where r2.deletions = 'N'
      and r2.release_status = 'in_content'
      and r2.not_for_distribution = 'N'
      and {% condition filter_isrc %} t2.isrc {% endcondition %}
      group by 1,2
       ;;
  }

  filter: filter_isrc {
    label: "Filter Isrc All Types Track Artists"
    view_label: "Track Artist Reportsar"
    type: string
  }

#   measure: count {
#     type: count
#     hidden: yes
#     drill_fields: [detail*]
#   }

  dimension: isrc {
    type: string
    hidden: yes
    sql: ${TABLE}.isrc ;;
  }

  dimension: upc {
    type: number
    hidden: yes
    sql: ${TABLE}.upc ;;
  }

  dimension: artist_name_all_types {
    view_label: "Track Artist Reportsar"
    label: "Artist Name (All Types)"
    description: "All Types of Artists and Multiple Names"
    type: string
    sql: ${TABLE}.key3 ;;
  }
#
#   set: detail {
#     fields: [isrc, upc, track_name, release_name, key2]
#   }
}