# View: track_artist_derived_table

**View Name:** track_artist_derived_table
**Table Source:** `Derived from: Art_Relations, Art_Relations.Releases, Art_Relations.Track, Art_Relations.Track_Artist`
**File Path:** `track_artist_derived_table.view.lkml`

## Overview

- **File Size:** 1198 bytes
- **Lines of Code:** 50
- **Dimensions:** 3
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 1

## Comments & Notes

- measure: count {
- type: count
- hidden: yes

## Dimensions

| Name | Type |
|------|------|
| `isrc` | string |
| `upc` | number |
| `artist_name_all_types` | string |

## Filters

- `filter_isrc`

## Derived Table

```sql
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 %
```