# View: art_relations_prod_film_genre_secondary

**View Name:** art_relations_prod_film_genre_secondary
**Table Source:** `orchard_app_reporting_v2.art_relations_prod_art_relations.film_genre
  derived_table: {
    sql: SELECT release_film_genre.release_id,
       Listagg(DISTINCT genre, ', ') as secondary_genres
            FROM   (SELECT *
                    FROM   orchard_app_reporting_v2.art_relations_prod_art_relations.release_film_genre
                    WHERE  release_film_genre.is_primary = 'N') release_film_genre
            LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.film_genre
            ON release_film_genre.film_genre_id = film_genre.film_genre_id
            GROUP  BY 1`
**File Path:** `art_relations_prod_film_genre_secondary.view.lkml`

## Overview

- **File Size:** 984 bytes
- **Lines of Code:** 32
- **Dimensions:** 2
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.film_genre
- - film_genre_id

## Dimensions

| Name | Type |
|------|------|
| `release_id` | number |
| `secondary_genres` | string |

## Derived Table

```sql
sql: SELECT release_film_genre.release_id,
       Listagg(DISTINCT genre, ', ') as secondary_genres
            FROM   (SELECT *
                    FROM   orchard_app_reporting_v2.art_relations_prod_art_relations.release_film_genre
                    WHERE  release_film_genre.is_primary = 'N') release_film_genre
            LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.film_genre
            ON release_film_genre.film_genre_id = film_genre.film_genre_id
            GROUP  BY 1
       ;;
```