# View: Delivery_App_Queue_Status

**View Name:** Delivery_App_Queue_Status
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Country, Art_Relations_Prod_Art_Relations.Customer_Master_Master, Prod.Nr_Contribution_Contributed_To_Nr_Sound_Recording, Prod.Nr_Contribution_Type, Prod.Performance_Nr_Contribution + 3 more`
**File Path:** `views/Delivery_App_Queue_Status.view.lkml`

## Overview

- **File Size:** 3388 bytes
- **Lines of Code:** 112
- **Dimensions:** 11
- **Measures:** 0
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Customer_Name` | string |
| `Contribution_UUID` | string |
| `Contributor_Name` | string |
| `NR_ID` | string |
| `Contributor_ID` | string |
| `Primary_Artist_Displayed_As` | string |
| `Song_Name` | string |
| `Recording_Version` | string |
| `ISRC` | string |
| `Contributor_Type` | string |
| `Valid` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `Last_Updated` | time |

## SQL Comments

- remove and cont.is_deleted not like true and include as default filter on looker
- the below lines have been added

## Derived Table

```sql
sql:
    select
cmm.customer_name,
dq.CONTRIBUTION_UUID,
nrbutor.name Contributor_Name,
sr.id NR_ID,
cont.nr_contributor_id Contributor_ID,
sr.main_artist Primary_Artist_Displayed_As,
sr.recording_title Song_Name,
    sr.version Recording_Version,
    sr.isrc ISRC,
    cont.contribution_type Contributor_Type,
    nrbution.valid Valid,
dq.LAST_UPDATED
from ORCHARD_APP_REPORTING_V2.PROD_PERFORMANCE_NR_DELIVERY_NEIGHBOURING_RIGHTS_DELIVERY.delivery_queue dq
LEFT JOIN ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.CUSTOMER_MASTER_MASTER cmm ON cmm.CUSTOMER_MASTER_MASTER_ID=dq.customer_master_master_id
left join FACTS.prod.PERFORMANCE_NR_CONTRIBUTION nrbution on dq.contribution_uuid = nrbution.id
inner join FACTS.prod.nr_contribution_type cont on nrbution.id = cont.nr_contribution_id  and cont.is_deleted not like true
inner join FACTS.prod.PERFORMANCE_NR_CONTRIBUTOR nrbutor on cont.nr_contributor_id = nrbutor.id
inner join FACTS.prod.nr_contribution_contributed_to_nr_sound_recording nsr on nrbution.id = nsr.nr_contribution_id
-- remove and cont.is_deleted not like true and include as default filter on looker
inner join FACTS.prod.PERFORMANCE_NR_SOUND_RECORDING sr on nsr.nr_sound_recording_id = sr.id  and sr.is_deleted not like true
left join orchard_app_reporting_v2.art_relations_prod_art_relations.country mc ON sr.country_of_master = mc.country_code
left join orchard_app_reporting_v2.art_relations_prod_art_relations.country cc ON nrbution.country_of_performance = cc.country_code
left join orchard_app_reporting_v2.art_relations_prod_art_relations.country cl ON sr.country_of_label = cl.country_code
-- the below lines have been added
left join table(flatten (input => sr.countries_of_recording, outer => TRUE)) cr
left join orchard_app_reporting_v2.art_relations_prod_art_relations.country cy on cy.country_code=cr.value
group by 1,2,3,4,5,6,7,8,9,10,11,12
order by cmm.customer_name, dq.LAST_UPDATED desc;;
```