# View: dt_content_validation_explicit_content

**View Name:** dt_content_validation_explicit_content
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_Art_Relations.Language, Art_Relations_Prod_Art_Relations.Mkt_Program_Info, Art_Relations_Prod_Art_Relations.Orchadmin_Users, Art_Relations_Prod_Art_Relations.Releases + 3 more`
**File Path:** `dt_content_validation_explicit_content.view.lkml`

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `tuid` | number |
| `release_id` | number |
| `description` | string |
| `explicit_word` | string |
| `matched_language` | string |
| `track_language` | string |

## Derived Table

```sql
sql:(SELECT r.upc, r.release_name, ai.name AS artist_name, r.sale_start_date, r.format, tr.id AS tuid, tr.isrc, tr.track_name, v.vendor_id AS label_id, IFF(v.company = '' OR v.company IS NULL, v.name, v.company) AS label_name, (oa.f_name || ' '||oa.l_name) AS label_manager, tr.meta_language AS track_language, 'english' AS matched_language, mpi.description, regexp_substr(regexp_replace(mpi.description,'[\r\n]+',''),'fuck|f\\*ck|fu\\*k|\\*uck|fuc\\*|c\\*nt|cu\\*t|cun\\*|\\*unt|cunt|\\*igg|n\\*gg|ni\\*g|nig\\*|nigg|\\*itch|b\\*tch|bi\\*ch|bit\\*h|bitc\\*|bitch|asshole|bullshit|whore|cocksucker|pussy',1,1,'i') AS explicit_word FROM orchard_app_reporting_v2.art_relations_prod_art_relations.mkt_program_info mpi INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.track tr ON tr.id = mpi.info_for_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.releases r ON r.release_id = tr.release_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ai ON r.artist_id = ai.artist_id INNER JOIN royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v ON ai.vendor_id = v.vendor_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.language l ON l.language_code=tr.meta_language LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.orchadmin_users oa ON v.assigned_to = oa.id WHERE mpi.info_for = 'track' AND l.language ILIKE '%english%' AND tr.explicit_lyrics = 'N' AND regexp_like(regexp_replace(mpi.description,'[\r\n]+',''),'.*fuck.*|.*f\\*ck.*|.*fu\\*k.*|.*fuc\\*.*|.*\\*uck.*|.*\\*unt.*|.*c\\*nt.*|.*cu\\*t.*|.*cun\\*.*|.*cunt.*|.*\\*igg.*|.*n\\*gg.*|.*ni\\*g.*|.*nig\\*.*|.*nigg.*|.*\\*itch.*|.*b\\*tch.*|.*bi\\*ch.*|.*bit\\*h.*|.*bitc\\*.*|.*bitch.*|.*asshole.*|.*bullshit.*|.*whore.*|.*cocksucker.*|.*pussy.*','i') AND tr.id <> '29334170' ORDER BY 4 ASC) UNION ALL
(SELECT r.upc, r.release_name, ai.name AS artist_name, r.sale_start_date, r.format, tr.id AS tuid, tr.isrc, tr.track_name, v.vendor_id AS label_id, IFF(v.company = '' OR v.company IS NULL, v.name, v.company) AS label_name, (oa.f_name || ' '||oa.l_name) AS label_manager, tr.meta_language AS track_language, 'french' AS matched_language, mpi.description, regexp_substr(regexp_replace(mpi.description,'[\r\n]+',''),'salope|pute|putain|conne|bordel|foutre%|biatch|niquer|enculer|enculé|enfoiré|merde|emmerder|emmerdé|connard|connasse|bâtard|chier|nègre|fuck|cunt|nigg|bitch|asshole|bullshit|whore|cocksucker',1,1,'i') AS explicit_word FROM orchard_app_reporting_v2.art_relations_prod_art_relations.mkt_program_info mpi INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.track tr ON tr.id = mpi.info_for_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.releases r ON r.release_id = tr.release_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ai ON r.artist_id = ai.artist_id INNER JOIN royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v ON ai.vendor_id = v.vendor_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.language l ON l.language_code=tr.meta_language LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.orchadmin_users oa ON v.assigned_to = oa.id WHERE mpi.info_for = 'track' AND l.language ILIKE '%french%' AND tr.explicit_lyrics = 'N' AND regexp_like(regexp_replace(mpi.description,'[\r\n]+',''),'.*salope.*|.*pute.*|.*putain.*|.*conne.*|.*bordel.*|.*foutre%.*|.*biatch.*|.*niquer.*|.*enculer.*|.*enculé.*|.*enfoiré.*|.*merde.*|.*emmerder.*|.*emmerdé.*|.*connard.*|.*connasse.*|.*bâtard.*|.*chier.*|.*nègre.*|.*fuck.*|.*cunt.*|.*nigg.*|.*bitch.*|.*asshole.*|.*bullshit.*|.*whore.*|.*cocksucker.*','i') AND tr.id <> '29334170' ORDER BY 4 ASC) UNION ALL
(SELECT r.upc, r.release_name, ai.name AS artist_name, r.sale_start_date, r.format, tr.id AS tuid, tr.isrc, tr.track_name, v.vendor_id AS label_id, IFF(v.company = '' OR v.company IS NULL, v.name, v.company) AS label_name, (oa.f_name || ' '||oa.l_name) AS label_manager, tr.meta_language AS track_language, 'italian' AS matched_language, mpi.description, regexp_substr(regexp_replace(mpi.description,'[\r\n]+',''),'merda|vaffanculo|fanculo|fottiti|inculati|stronzo|coglione|pezzo di merda|testa di cazzo|figlio di puttana|figlio di troia|stronzo|coglione|bastardo|troia|puttana|baldracca|culo|cazzo|minchia|cazzata|fuck|cunt|nigg|bitch|asshole|bullshit|whore|cocksucker',1,1,'i') AS explicit_word FROM orchard_app_reporting_v2.art_relations_prod_art_relations.mkt_program_info mpi INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.track tr ON tr.id = mpi.info_for_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.releases r ON r.release_id = tr.release_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ai ON r.artist_id = ai.artist_id INNER JOIN royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v ON ai.vendor_id = v.vendor_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.language l ON l.language_code=tr.meta_language LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.orchadmin_users oa ON v.assigned_to = oa.id WHERE mpi.info_for = 'track' AND l.language ILIKE '%italian%' AND tr.explicit_lyrics = 'N' AND regexp_like(regexp_replace(mpi.description,'[\r\n]+',''),'.*merda.*|.*vaffanculo.*|.*fanculo.*|.*fottiti.*|.*inculati.*|.*stronzo.*|.*coglione.*|.*pezzo di merda.*|.*testa di cazzo.*|.*figlio di puttana.*|.*figlio di troia.*|.*stronzo.*|.*coglione.*|.*bastardo.*|.*troia.*|.*puttana.*|.*baldracca.*|.*culo.*|.*cazzo.*|.*minchia.*|.*cazzata.*|.*fuck.*|.*cunt.*|.*nigg.*|.*bitch.*|.*asshole.*|.*bullshit.*|.*whore.*|.*cocksucker.*','i') AND tr.id <> '29334170' ORDER BY 4 ASC) UNION ALL
(SELECT r.upc, r.release_name, ai.name AS artist_name, r.sale_start_date, r.format, tr.id AS tuid, tr.isrc, tr.track_name, v.vendor_id AS label_id, IFF(v.company = '' OR v.company IS NULL, v.name, v.company) AS label_name, (oa.f_name || ' '||oa.l_name) AS label_manager, tr.meta_language AS track_language, 'korean' AS matched_language, mpi.description, regexp_substr(regexp_replace(mpi.description,'[\r\n]+',''),'썅|씨발|씹|지랄”|새끼|년|fuck|cunt|nigg|bitch|asshole|bullshit|whore|cocksucker',1,1,'i') AS explicit_word FROM orchard_app_reporting_v2.art_relations_prod_art_relations.mkt_program_info mpi INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.track tr ON tr.id = mpi.info_for_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.releases r ON r.release_id = tr.release_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ai ON r.artist_id = ai.artist_id INNER JOIN royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v ON ai.vendor_id = v.vendor_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.language l ON l.language_code=tr.meta_language LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.orchadmin_users oa ON v.assigned_to = oa.id WHERE mpi.info_for = 'track' AND l.language ILIKE '%korean%' AND tr.explicit_lyrics = 'N' AND regexp_like(regexp_replace(mpi.description,'[\r\n]+',''),'.*썅.*|.*씨발.*|.*씹.*|.*지랄”.*|.*새끼.*|.*년.*|.*fuck.*|.*cunt.*|.*nigg.*|.*bitch.*|.*asshole.*|.*bullshit.*|.*whore.*|.*cocksucker.*','i') AND tr.id <> '29334170' ORDER BY 4 ASC) UNION ALL
(SELECT r.upc, r.release_name, ai.name AS artist_name, r.sale_start_date, r.format, tr.id AS tuid, tr.isrc, tr.track_name, v.vendor_id AS label_id, IFF(v.company = '' OR v.company IS NULL, v.name, v.company) AS label_name, (oa.f_name || ' '||oa.l_name) AS label_manager, tr.meta_language AS track_language, 'portuguese' AS matched_language, mpi.description, regexp_substr(regexp_replace(mpi.description,'[\r\n]+',''),'Foda|Caralho|Foder|Filho da puta|Sapatona|Merda|Filho da puta|Babaca|Puta|Piranha|Viado|Viado|Cuzão|Merda|Bastardo|Burro|Foda|Bacanal|Buceta|Bunda|Cabaço|Caralho|Cretina|FDP|Pereca|Perereca|Piranha|Piroca|Porra|Putaria|Putianes|Putinha|Putinhas|Rabeta|Rabuda|Sacanagem|Xereca|fuck|cunt|nigg|bitch|asshole|bullshit|whore|cocksucker',1,1,'i') AS explicit_word FROM orchard_app_reporting_v2.art_relations_prod_art_relations.mkt_program_info mpi INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.track tr ON tr.id = mpi.info_for_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.releases r ON r.release_id = tr.release_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ai ON r.artist_id = ai.artist_id INNER JOIN royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v ON ai.vendor_id = v.vendor_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.language l ON l.language_code=tr.meta_language LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.orchadmin_users oa ON v.assigned_to = oa.id WHERE mpi.info_for = 'track' AND l.language ILIKE '%portuguese%' AND tr.explicit_lyrics = 'N' AND regexp_like(regexp_replace(mpi.description,'[\r\n]+',''),'.*Foda.*|.*Caralho.*|.*Foder.*|.*Filho da puta.*|.*Sapatona.*|.*Merda.*|.*Filho da puta.*|.*Babaca.*|.*Puta.*|.*Piranha.*|.*Viado.*|.*Viado.*|.*Cuzão.*|.*Merda.*|.*Bastardo.*|.*Burro.*|.*Foda.*|.*Bacanal.*|.*Buceta.*|.*Bunda.*|.*Cabaço.*|.*Caralho.*|.*Cretina.*|.*FDP.*|.*Pereca.*|.*Perereca.*|.*Piranha.*|.*Piroca.*|.*Porra.*|.*Putaria.*|.*Putianes.*|.*Putinha.*|.*Putinhas.*|.*Rabeta.*|.*Rabuda.*|.*Sacanagem.*|.*Xereca.*|.*fuck.*|.*cunt.*|.*nigg.*|.*bitch.*|.*asshole.*|.*bullshit.*|.*whore.*|.*cocksucker.*','i') AND tr.id <> '29334170' ORDER BY 4 ASC) UNION ALL
(SELECT r.upc, r.release_name, ai.name AS artist_name, r.sale_start_date, r.format, tr.id AS tuid, tr.isrc, tr.track_name, v.vendor_id AS label_id, IFF(v.company = '' OR v.company IS NULL, v.name, v.company) AS label_name, (oa.f_name || ' '||oa.l_name) AS label_manager, tr.meta_language AS track_language, 'russian' AS matched_language, mpi.description, regexp_substr(regexp_replace(mpi.description,'[\r\n]+',''),'говно|ебать|пизда|хуесос|мудила|жопа|сука|член|шлюха|дерьмо|трахать|манда|очко|хуй|блядь|fuck|cunt|nigg|bitch|asshole|bullshit|whore|cocksucker',1,1,'i') AS explicit_word FROM orchard_app_reporting_v2.art_relations_prod_art_relations.mkt_program_info mpi INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.track tr ON tr.id = mpi.info_for_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.releases r ON r.release_id = tr.release_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ai ON r.artist_id = ai.artist_id INNER JOIN royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v ON ai.vendor_id = v.vendor_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.language l ON l.language_code=tr.meta_language LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.orchadmin_users oa ON v.assigned_to = oa.id WHERE mpi.info_for = 'track' AND l.language ILIKE '%russian%' AND tr.explicit_lyrics = 'N' AND regexp_like(regexp_replace(mpi.description,'[\r\n]+',''),'.*говно.*|.*ебать.*|.*пизда.*|.*хуесос.*|.*мудила.*|.*жопа.*|.*сука.*|.*член.*|.*шлюха.*|.*дерьмо.*|.*трахать.*|.*манда.*|.*очко.*|.*хуй.*|.*блядь.*|.*fuck.*|.*cunt.*|.*nigg.*|.*bitch.*|.*asshole.*|.*bullshit.*|.*whore.*|.*cocksucker.*','i') AND tr.id <> '29334170' ORDER BY 4 ASC) UNION ALL
(SELECT r.upc, r.release_name, ai.name AS artist_name, r.sale_start_date, r.format, tr.id AS tuid, tr.isrc, tr.track_name, v.vendor_id AS label_id, IFF(v.company = '' OR v.company IS NULL, v.name, v.company) AS label_name, (oa.f_name || ' '||oa.l_name) AS label_manager, tr.meta_language AS track_language, 'spanish' AS matched_language, mpi.description, regexp_substr(regexp_replace(mpi.description,'[\r\n]+',''),'joder|carajo|coger|hijo de puta|chancla|mierda|hijo de perra|pendejo|puta|zorra|marica|maricón|mamón|mierda|bastardo|culo|Gilipollas|abrón|Tonto del culo|Puta madre|fuck|cunt|nigg|bitch|asshole|bullshit|whore|cocksucker',1,1,'i') AS explicit_word FROM orchard_app_reporting_v2.art_relations_prod_art_relations.mkt_program_info mpi INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.track tr ON tr.id = mpi.info_for_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.releases r ON r.release_id = tr.release_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ai ON r.artist_id = ai.artist_id INNER JOIN royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v ON ai.vendor_id = v.vendor_id INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.language l ON l.language_code=tr.meta_language LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.orchadmin_users oa ON v.assigned_to = oa.id WHERE mpi.info_for = 'track' AND l.language ILIKE '%spanish%' AND tr.explicit_lyrics = 'N' AND regexp_like(regexp_replace(mpi.description,'[\r\n]+',''),'.*joder.*|.*carajo.*|.*coger.*|.*hijo de puta.*|.*chancla.*|.*mierda.*|.*hijo de perra.*|.*pendejo.*|.*puta.*|.*zorra.*|.*marica.*|.*maricón.*|.*mamón.*|.*mierda.*|.*bastardo.*|.*culo.*|.*Gilipollas.*|.*abrón.*|.*Tonto del culo.*|.*Puta madre.*|.*fuck.*|.*cunt.*|.*nigg.*|.*bitch.*|.*asshole.*|.*bullshit.*|.*whore.*|.*cocksucker.*','i') AND tr.id <> '29334170' ORDER BY 4 ASC);;
```