view: subgenre {
  sql_table_name: art_relations.subgenre ;;

  dimension: genre_id {
    type: yesno
    # hidden: yes
    sql: ${TABLE}.genre_id ;;
  }

  dimension: music_video {
    type: string
    sql: ${TABLE}.music_video ;;
  }

  dimension: name {
    type: string
    sql: ${TABLE}.name ;;
  }

  dimension: orchard_id {
    type: number
    sql: ${TABLE}.orchard_id ;;
  }

  measure: count {
    type: count
    drill_fields: [name, genre.genre_id]
  }
}