what is the {MusicBrainz artist ID} for {Merzbow} has {pseudonym} as {SCUM} ?
Is artist MusicBrainz also known as SCUM?
Tell me the MusicBrainz artist ID for Merzbow has pseudonym as SCUM?
SELECT ?v WHERE { ?u property:MusicBrainz_artist_ID ?v . resource:Merzbow property:pseudonym ?u . ?u property:pseudonym ?z . FILTER ( CONTAINS ( ?z , 'SCUM' ) ) }
select distinct ?value  where {
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#subject> <http://wikidata.dbpedia.org/resource/Q452011> .
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#predicate> <http://www.wikidata.org/entity/P742> .
?statement <http://www.w3.org/1999/02/22-rdf-syntax-ns#object> <SCUM> .
?statement <http://www.wikidata.org/entity/P434> ?value. 
} 

SELECT ?value WHERE { wd:Q452011 p:P742 ?s . ?s ps:P742 ?x filter(contains(?x , 'SCUM')) . ?s pq:P434 ?value}