"""Snowflake SQL query to retrieve metadata update queue information for sound recordings takedown.""" META_UPDATE_QUEUE_QUERY = """ SELECT (TO_CHAR(TO_DATE(meta_update_queue.date_added ), 'YYYY-MM-DD')) AS "meta_update_queue.date_added", facts_prod_dim_label.labelid AS "facts_prod_dim_label.label_id", facts_prod_dim_label.labelname AS "facts_prod_dim_label.label_name", orch_app_ar_artist_info.name AS "orch_app_ar_artist_info.name", orch_app_ar_track.track_name AS "orch_app_ar_track.track_name", orch_app_ar_releases.upc AS "orch_app_ar_releases.upc", orch_app_ar_track.isrc AS "orch_app_ar_track.isrc" FROM ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.META_UPDATE_QUEUE AS meta_update_queue INNER JOIN ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.META_UPDATE_DMS_MASTER AS meta_update_dms_master ON meta_update_dms_master.meta_update_queue_id=meta_update_queue.meta_update_queue_id LEFT JOIN ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.CUSTOMER_MASTER_MASTER AS orch_app_ar_customer_master_master ON meta_update_dms_master.customer_master_master_id=orch_app_ar_customer_master_master.CUSTOMER_MASTER_MASTER_ID LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.releases AS orch_app_ar_releases ON meta_update_queue.upc=orch_app_ar_releases.upc LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info AS orch_app_ar_artist_info ON orch_app_ar_artist_info.artist_id=orch_app_ar_releases.artist_id LEFT JOIN facts.prod.dim_label AS facts_prod_dim_label ON orch_app_ar_artist_info.vendor_id=facts_prod_dim_label.labelid INNER JOIN intelligence.dbt_prod.orch_app_ar_track_track_physical_joined AS orch_app_ar_track ON orch_app_ar_track.release_id = orch_app_ar_releases.release_id WHERE ((( meta_update_queue.date_added ) >= '{last_run}' AND ( meta_update_queue.date_added ) < '{current_run}')) AND (orch_app_ar_releases.distribution_format_id ) = 1 GROUP BY (TO_DATE(meta_update_queue.date_added )), 2, 3, 4, 5, 6, 7 HAVING (UPPER((( listagg(DISTINCT orch_app_ar_customer_master_master.CUSTOMER_NAME, ', ') WITHIN GROUP (ORDER BY orch_app_ar_customer_master_master.CUSTOMER_NAME) ))) LIKE UPPER('%YouTube Content ID%')) ORDER BY 7 DESC """ ISRC_LOOKUP_QUERY = """ WITH dt_split_release_artists AS (SELECT sub_table.*, gp_r_lp.global_participant_id, gp_r_lp.label_participant_id FROM facts.prod.release_artist ra INNER JOIN facts.prod.ORCHARD_PRODUCT AS dr ON dr.id = ra.product_id LEFT JOIN ( SELECT product_id, label_participant_uuid, rel.participated_as as role, lp.name, lp.normalized_name FROM facts.prod.label_participant_participated_in_orchard_product rel inner JOIN facts.prod.label_participant lp ON rel.label_participant_uuid = lp.uuid ) sub_table ON ra.product_id = sub_table.product_id and ra.role = sub_table.role and sub_table.normalized_name = lower(trim(regexp_replace(ra.name, '[ ]+', ''), ' \t\n\u000B\f\r\u001C\u001D\u001E\u001F\u1680\u2000\u2001\u2002\u2003\u2004\u2005\u2006\u2008\u2009\u200A\u205F\u3000\u2028\u2029')) INNER JOIN facts.prod.global_participant_represents_label_participant gp_r_lp ON gp_r_lp.label_participant_uuid = sub_table.label_participant_uuid) SELECT orch_app_ar_vendor.vendor_id AS "orch_app_ar_vendor.vendor_id", IFF(orch_app_ar_vendor.company IS NULL OR orch_app_ar_vendor.company = '', orch_app_ar_vendor.name, orch_app_ar_vendor.company) AS "orch_app_ar_vendor.label_name", orch_app_ar_releases.label AS "orch_app_ar_releases.imprint_name", orch_app_ar_artist_info.artist_id AS "orch_app_ar_artist_info.artist_id", orch_app_ar_artist_info.name AS "orch_app_ar_artist_info.name", dt_track_artist_by_type.primary_artists AS "dt_track_artist_by_type.primary_artists", orch_app_ar_releases.display_upc AS "orch_app_ar_releases.display_upc", orch_app_ar_releases.release_name AS "orch_app_ar_releases.release_name", (CASE WHEN orch_app_ar_releases.deletions = 'Y' THEN 'Yes' ELSE 'No' END) AS "orch_app_ar_releases.is_deleted", orch_app_ar_track.id AS "orch_app_ar_track.tuid", orch_app_ar_track.isrc AS "orch_app_ar_track.isrc", orch_app_ar_track.track_name AS "orch_app_ar_track.track_name" FROM orchard_app_reporting_v2.art_relations_prod_art_relations.owner AS orch_app_ar_owner INNER JOIN royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor AS orch_app_ar_vendor ON lower(orch_app_ar_owner.owner_abbrivation) = lower(orch_app_ar_vendor.owner) INNER JOIN intelligence.dbt_prod.dt_access_filter_1091 AS dt_access_filter_1091 ON orch_app_ar_vendor.vendor_id = dt_access_filter_1091.vendor_id LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.vendor_transaction_type_contract AS orch_app_ar_vendor_transaction_type_contract ON orch_app_ar_vendor_transaction_type_contract.vendor_id = orch_app_ar_vendor.vendor_id LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info AS orch_app_ar_artist_info ON orch_app_ar_vendor.vendor_id = orch_app_ar_artist_info.vendor_id LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.releases AS orch_app_ar_releases ON orch_app_ar_artist_info.artist_id = orch_app_ar_releases.artist_id LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.distribution_format AS orch_app_ar_distribution_format ON orch_app_ar_releases.distribution_format_id = orch_app_ar_distribution_format.distribution_format_id INNER JOIN intelligence.dbt_prod.orch_app_ar_track_track_physical_joined AS orch_app_ar_track ON orch_app_ar_track.release_id = orch_app_ar_releases.release_id LEFT JOIN INTELLIGENCE.DBT_PROD.DT_TRACK_ARTIST_BY_TYPE AS dt_track_artist_by_type ON orch_app_ar_track.id = dt_track_artist_by_type.tuid LEFT JOIN facts.prod.dim_release AS facts_prod_dim_release ON orch_app_ar_releases.upc = facts_prod_dim_release.releaseid LEFT JOIN dt_split_release_artists ON facts_prod_dim_release.product_id=(dt_split_release_artists."PRODUCT_ID") WHERE orch_app_ar_track.isrc IN ({isrc_list}) AND ((orch_app_ar_vendor.vendor_id ) NOT IN (894, 7514, 7667, 8020, 8062, 8119, 8138, 8174, 8409, 8446, 8529, 8568, 8673, 8861, 9067, 9159, 9304, 9349, 9594, 9802, 10693, 10883, 11726, 11818, 12242, 12370, 12527, 12596, 12669, 14033, 14061, 14110, 14237, 14251, 14253, 14265, 14271, 14504, 14659, 14707, 14767, 14835, 14881, 15078, 15094, 15292, 15354, 15384, 15417, 15433, 15447, 15499, 15624, 15691, 15744, 15752, 15766, 15950, 15952, 16015, 16052, 16082, 16099, 16143, 16211, 16305, 16345, 16351, 16402, 16420, 16422, 16492, 16494, 16529, 16530, 16570, 16600, 16728, 16730, 16790, 16791, 16814, 16841, 16915, 16943, 17020, 17048, 17075, 17103, 17124, 17127, 17128, 17168, 17176, 17195, 17274, 17292, 17298, 17299, 17304, 17516, 17651, 17685, 17708, 17939, 17958, 17960, 18009, 18093, 18499, 18730, 18819, 18859, 18920, 19054, 19187, 19353, 19961, 19973, 20022, 20557, 20581, 20798, 20908, 21015, 21462, 21523, 21538, 21563, 21851, 21858, 22088, 22158, 22184, 22224, 22547, 22568, 22592, 22734, 22872, 23094, 23104, 23464, 23492, 23524, 23533, 23648, 23681, 24028, 24439, 24502, 24820, 24823, 24961, 25169, 25257, 25323, 25343, 25444, 25547, 25824, 26045, 26754, 26985, 27034, 27529, 27758, 28117, 28675, 28774, 28796, 28905, 29154, 32551, 32946, 33088, 33878, 33961, 35071) OR (orch_app_ar_vendor.vendor_id ) IS NULL) AND ((UPPER(( orch_app_ar_releases.release_status )) = UPPER('in_content'))) AND ((NOT (orch_app_ar_releases.deletions = 'Y' ) OR (orch_app_ar_releases.deletions = 'Y' ) IS NULL) AND (((UPPER(( orch_app_ar_releases.not_for_distribution )) = UPPER('N'))) AND (orch_app_ar_releases.release_status = 'in_content' AND orch_app_ar_releases.deletions = 'N' AND orch_app_ar_releases.not_for_distribution = 'N' ))) AND (((UPPER(( orch_app_ar_distribution_format.context_type )) = UPPER('digital'))) AND ((UPPER(( orch_app_ar_track.track_type )) = UPPER('music'))) AND (((UPPER(( orch_app_ar_track.offer_type )) <> UPPER('album_download_only') AND UPPER(( orch_app_ar_track.offer_type )) <> UPPER('album_track_download') AND UPPER(( orch_app_ar_track.offer_type )) <> UPPER('none') AND UPPER(( orch_app_ar_track.offer_type )) <> UPPER('track_download_only') OR ( orch_app_ar_track.offer_type ) IS NULL)) AND (((UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Whispering Jack Smith') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Adamo Didur') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Adelina Patti') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Adolf Busch') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Adrian Rollini') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Agustin Magaldi') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Aissa Djermouni') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Al Bowlly') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Al Jolson') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Albert Ammons') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Aleksander Wertyński') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Alessandro Bonci') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Alexander Gauk') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Alfred Cortot') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Alfred Piccaver') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Amede Ardoin') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Amelita Galli-Curci') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Andy Sanella') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Ángel Vargas') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Angel Viloria') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Antonio Cortis') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Antonio Magini-Coletti') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Antonio Paoli') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Antonio Scotti') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Aristide Bruant') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Armand Crabbe') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Armand Tokatyan') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Armida Parsi-Pettinella') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Art Tatum') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Arthur Fields') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Artur Schnabel') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Arturo Toscanini') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Ashworth Hope') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Asmahan') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Ataúlfo Argenta') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Augustín Magaldi') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Aureliano Pertile') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Barbecue Bob') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Benedito Lacerda') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Beniamino Gigli') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Bennie Moten') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Beny More') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Beny more') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Bernardo de Muro') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Bertha Chippie Hill') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Berthe Sylva') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Bessie Smith') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Beverly Kenney') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Big Bill Broonzy') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Big Maceo Merriweather') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Big Sid Catlett') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Billie Holiday') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Bix Beiderbecke') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Blind Blake') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Blind Boy Fuller') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Blind Lemon Jefferson') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Blind Roosevelt Graves') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Blind Willie Johnson') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Blind Willie McTell') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Bob Scobey') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Bob Zurke') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Bobby Fuller') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Booker Little') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Boris Vian') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Bruce Falconer') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Bruno Walter') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Bubber Miley') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Buddy Clark') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Buddy Holly') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Bunk Johnson') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Bunny Berigan') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Carlo Buti') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Carlos Di Sarli') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Carlos Gardel') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Carmen Amaya') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Carmen Miranda') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Carolina Slim') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Cayetano Muriel') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Cecil Gant') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Chano Pozo') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Charley Patton') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Charlie Christian') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Charlie Kunz') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Charlie Parker') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Charlie Poole') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Cheikh Raymond') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Chick Webb') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Chris Velasco') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Christina Georgina Rossetti') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Chu Berry') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Chuck Willis') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Cisco Houston') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Clara Haskil') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Clara Smith') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Clarence Profit') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Claudia Muzio') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Clemens Krauss') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Clifford Brown') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Coenraad V. Bos') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Conchita Supervia') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Cow Cow Davenport') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Cripple Clarence Lofton') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Dennis Brain') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Dinah Washington') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Dinu Lipatti') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Dixieland Jug Blowers') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Django Reinhardt') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Dranem') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Duane Eddy') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Duncan Watt') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Earl Bostic') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Eddie Cochran') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Eddie Costa') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Eddie Lang') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Eddie South') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Eddy Duchin') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Edith Piaf') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Eduardo Bianco') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Edward Brophy') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Edwin Fischer') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Elisabeth Schumann') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Ella Retford') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Elmore James') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Enrico Caruso') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Eric Dolphy') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Erich Kleiber') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Erroll Garner') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Eugène Ysaÿe') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Ezio Pinza') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Fanny Brice') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Fats Navarro') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Fats Waller') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Felix Weingartner') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Feodor Chaliapin') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Fernando de Lucia') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Flanagan & Allen') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Fletcher Henderson') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Florrie Forde') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Francis Scrapper Blackwell') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Francisco Canaro') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Frank Crumit') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Frank Teschemacher') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Frankie Newton') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Fred Buscaglione') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Fred Van Eps') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Freddie Keppard') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Freddy Gardner') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Frehel') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Fritz Busch') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Fritz Kreisler') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Fritz Reiner') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Genaro Salinas') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('George Baklanov') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('George Formby') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('George Gershwin') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Gertrude Lawrence') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('GHM Sound Team') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Giacomo Puccini') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Gid Tanner') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Gino Marinuzzi') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Glen Miller') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Glenn Miller') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Hafız Burhan') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Hambone Willie Newbern') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Hank Williams') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Hans Albers') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Harry Champion') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Harry Choates') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Heinrich Schlusnus') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Helen Carr') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Henri Garat') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Henry Thomas') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Herbie Fields') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Herbie Nichols') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Herman Jadlowker') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Huddie William Ledbetter') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Ignacy Jan Paderewski') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Ike Quebec') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Irving Aaronson') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Isham Jones') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Ivy Anderson') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jack Hylton') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jack Teagarden') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jacques Thibaud') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('James Reese Europe') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jean Goldkette') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jeanne Gerville-Réache') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jelly Roll Morton') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jim Reeves') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jimmie Grier') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jimmie Lunceford') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jimmie Rodgers') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jimmy Blanton') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jimmy Dorsey') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jimmy Lunceford') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jimmy Noone') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jimmy Yancey') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('John Charles Thomas') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('John Lee Sonny Boy Williamson') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('John McCormack') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Johnny Ace') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Johnny Burnett') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Johnny Dodds') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Johnny Horton') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Johnny Noble') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jorge Negrete') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Josef Mann') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Juan Maglio') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Juli Garetta') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Julia Lee') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Julio Sosa') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Jussi Björling') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Kansas Joe McCoy') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Kathleen Ferrier') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Kevin McMullan') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('King Oliver') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Komitas Vardapet') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Leadbelly') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Lee Morse') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Lem Winchester') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Leo Parker') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Leo Reisman') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Leo Slezak') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Leo Watson') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Leon Chu Berry') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Leonard Warren') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Leroy Foster') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Lester Young') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Lil Green') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Lord Invader') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Lou And His Ginger Snaps') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Lou Merrill') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Louis Armstrong') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Lucienne Delyle') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Luigi Montesanto') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Luis Russell') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Ma Rainey') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Mado Robin') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Mamie Smith') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Manuel Escacena') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Marcel Journet') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Marcelle Meyer') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Maria Tanase') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Marilyn Monroe') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Mario Lanza') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Martin O''Donnell') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Max Miller') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Mercy Dee Walton') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Metronome All-Stars') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Midge Williams') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Miff Mole') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Mildred Bailey') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Mississippi John Hurt') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Mistinguett') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Montana Taylor') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Nellie Melba') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('New Orleans Rhythm Kings') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('New Orleans Wanderers') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Nicola Fusati') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Nobuo Uematsu') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Noor Jehan') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Norfolk Jubilee Quartet') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Oleksa Lozowchuk') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Original Dixieland Jazz Band') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Oscar Pettiford') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Papa Charlie Jackson') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Pasquale Amato') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Patsy Cline') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Paul van Kempen') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Pedro Infante') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Peetie Wheatstraw') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Peter Anders') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Peter Antovski') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Peter Dawson') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Peter Warlock') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Petri Alanko') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Pierre Estève') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Posey Rorer') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Putney Dandridge') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Pyotr Leshchenko') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Ramon Montoya') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Red McKenzie') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Refik Başaran') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Riccardo Stracciari') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Richard M. Jones') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Richard Tauber') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Ritchie Valens') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Robert Johnson') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Saleh Abdel Hay') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Sara Martin') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Sayed Darwish') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Scott Joplin') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Scott LaFaro') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Scrapper Blackwell') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Serge Chaloff') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Sergei Rachmaninoff') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Shep & The Limelights') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Sid Catlett') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Sidney Bechet') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Sir Harry Lauder') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Sir Thomas Beecham') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Six Brown Brothers') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Smokey Hogg') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Sol Hoopii') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Sonny Clarke') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Sonny Parker') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Stanley Kirkby') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Stéphane') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Stephen Rippy') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Stick(s) McGhee') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Tanburi Cemil Bey') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Ted Weems') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Terry Snyder') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Texas Alexander') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Almanac Singers') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Barry Sisters') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Big Bopper') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Bucktown Five') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Cadillacs') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Carter Family') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Comedian Harmonists') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Delmore Brothers') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Dorsey Brothers') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Goofus Five') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Ink Spots') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Little Ramblers') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Memphis Jug Band') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Merry Macs') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Pied Pipers') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Robins') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Satintones') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('The Tune Wranglers') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Thomas Morris') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Tiny Bradshaw') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Tiny Parham') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Titta Ruffo') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Tomas Pavon') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Tommy Dorsey') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Tommy Johnson') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Tommy McClennan') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Una Mae Carlisle') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Vernon Dalhart') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Vesta Tilley') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Vesta Victoria') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Walter Gieseking') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Wanda Landowska') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Wardell Gray') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Wilhelm Furtwangler') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Will Hay') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Willem Mengelberg') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Willie Brown') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Zhou Xuan') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Artistas Variados') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Artistas Varios') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Artistes variés') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Artisti vari') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Blandade artister') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Çesitli Sanatçilar') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Çeşitli Sanatcılar') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Çeşitli Sanatçılar') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Divers') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Divers artistes') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Diverse artiesten') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Diverse Artister') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Interpretes Varios') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Különböző előadók') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Les artistes varies') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Multi-interprètes') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Multiple Artists') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Quelques Artistes') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Vari artisti') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Varies Artist') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Varioius Artists') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Varios') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Vários') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Varios Artistas') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Vários Artistas') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Varios interpretes') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Vários Intérpretes') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Variours Artists') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Various') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Various Arists') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Various Aritists') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Various Aritsts') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Various Artist') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Various Artistes') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Various Artistis') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Various Artists') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Various Artists (YouTube)') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Varius Artist') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Varoius Artitists') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Varous Artists') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Verschiedene Interpreten') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Verschiedene Künstler') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Verskeie Kunstenaars') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Различные исполнители') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Разные Артисты') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('Сборник') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('אמנים שונים') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('各种各样的艺术家') AND UPPER(( dt_split_release_artists."NAME" )) <> UPPER('各種各樣的藝術家') OR ( dt_split_release_artists."NAME" ) IS NULL)) AND (dt_access_filter_1091.access_control ) = 2))) GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 ORDER BY 1 """