# View: Lauv_catalogue_report

**View Name:** Lauv_catalogue_report
**Table Source:** `Derived from: Awal_Sax, Awal_Sax.Sax, Sax.Exp_Version_Recordings, Sax.Exp_Versions, Sax.Expv_Configurations + 1 more`
**File Path:** `DOSC/Detailed_catalogue_report/views/Lauv_catalogue_report.view.lkml`

## Overview

- **File Size:** 1535 bytes
- **Lines of Code:** 53
- **Dimensions:** 6
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `ean` | string |
| `product_title` | string |
| `product_version` | string |
| `isrc` | string |
| `recording_title` | string |
| `recording_version` | string |

## Derived Table

```sql
sql:
      select
        distinct expv_configurations.ean, exploitations.EXPLOITATION_TITLE, exp_versions.subtitle, disc_number, track_number, isrc, recordings.title, recordings.sub_title
      from
        awal_sax.sax.exploitations
        inner join awal_sax.sax.exp_versions on exp_versions.exploitation_id = exploitations.id
        inner join awal_sax.sax.expv_configurations on expv_configurations.exp_version_id = exp_versions.id
        inner join awal_sax.sax.exp_version_recordings on exp_version_recordings.exp_version_id = exp_versions.id
        inner join awal_sax.sax.recordings on recordings.id = exp_version_recordings.recording_id
        inner join awal_sax.sax.recording_artists on EXPLOITATION_ARTIST_ID = recording_artists.id
      where recording_artists.name = 'Lauv'
        order by ean, disc_number, track_number;;
```