query-03c7884f6af6abcdfe1276517fc64713

rq turtle/ttl

Same as above, but this time looking at the item's alias:

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?role ?roleLabel ?role_alias ?play ?playLabel
WHERE 
{
  ?play wdt:P31/wdt:P279* wd:Q25379.
  ?role wdt:P31/wdt:P279* wd:Q95074.
  ?role wdt:P1441 ?play.
  ?role skos:altLabel ?role_alias.
  FILTER (contains(lcase(?role_alias), 'sein')|| contains(lcase(?role_alias), 'ihr') || contains(lcase(?role_alias), 'deren') || contains(lcase(?role_alias), 'dessen') ).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?play"):::projected v3("?role"):::projected v1("?role_alias"):::projected a1((" ")) a2((" ")) c7(["wd:Q25379"]):::iri c14(["de"]):::literal c8(["wd:Q95074"]):::iri c12(["bd:serviceParam"]):::iri f0[["(contains(lower-case(?role_alias),'sein') || (contains(lower-case(?role_alias),'ihr') || (contains(lower-case(?role_alias),'deren') || contains(lower-case(?role_alias),'dessen'))))"]] f0 --> v1 v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c7 v3 --"wdt:P31"--> a2 a2 --"wdt:P279"--> c8 v3 --"wdt:P1441"--> v2 v3 --"skos:altLabel"--> v1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end