# View: signed_labels_deleted_content

**View Name:** signed_labels_deleted_content
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_Art_Relations.Releases, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations, Prod.Vw_Dim_Abacus_Ar_Vendor + 2 more`
**File Path:** `signed_labels_deleted_content.view.lkml`

## Overview

- **File Size:** 2407 bytes
- **Lines of Code:** 70
- **Dimensions:** 2
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- This view shows the list of vendor IDs that have a status of signed, but all content deleted

## Dimensions

| Name | Type |
|------|------|
| `vendor_id` | number |
| `signed_label_deleted_content` | yesno |

## Measures

| Name | Type |
|------|------|
| `count` | count |

## Derived Table

```sql
sql:select releases_count.vendor_id
      from(
          select all_count.vendor_id
                  , deleted_releases
                  , all_releases
                  , deleted_releases - all_releases as releases_diff
          from  (
                select v.vendor_id
                     , count(distinct r.upc) as all_releases
              from orchard_app_reporting_v2.art_relations_prod_art_relations.releases r
              left join orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ai on r.artist_id=ai.artist_id
              left join royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v on ai.vendor_id=v.vendor_id
              where r.release_status='in_content'
              and r.not_for_distribution='N'
              group by 1
              ) all_count

          inner join

          (    select v.vendor_id
                     , count(distinct r.upc) as deleted_releases
              from orchard_app_reporting_v2.art_relations_prod_art_relations.releases r
              left join orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ai on r.artist_id=ai.artist_id
              left join royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v on ai.vendor_id=v.vendor_id
              where r.deletions='Y'
              and r.release_status='in_content'
              and r.not_for_distribution='N'
              group by 1
              ) deleted_count
           on deleted_count.vendor_id=all_count.vendor_id
          where all_releases>0
        ) releases_count

      left join royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v on v.vendor_id=releases_count.vendor_id
      where releases_diff=0
      and v.status='signed'
      and v.label_identifier!='Test'
      order by 1
       ;;
```