query-625bf1366a0ce1fcc40a0ceaf2f41080

rq turtle/ttl

Querying Wikidata & Editing WikipediaUse the query below to list actors and actresses who appeared in theatrical productions of Schauspielhaus Zürich but do not have an entry in the German Wikipedia (the query ranks the actors according to the number of their appearances. Search for information about said actors/actresses and write a short Wikipedia article about them. For people preferring to edit Wikipedia in English, French, Italian, etc.:Adapt the query below to output the same list, but for actors and actresses who do not have an entry in your language. Add the query below. Create Wikipedia articles in your language. For advanced users:The query below counts the number of appearances, counting actors who appeared several times in the same production (different roles) more than once. Adapt the query to indicate the number of individual productions in which the actor/actress appeared instead of providing the number of appearances. List the adapted query below. Create a list of all actors and actresses who appeared in theatrical productions of Schauspielhaus Zürich in the order of the number of their appearances with an overview which artists have a Wikipedia entry in which language. Querying Wikidata & Editing WikipediaUse the query below to list actors and actresses who appeared in theatrical productions of Schauspielhaus Zürich who do not have an entry in the German Wikipedia in the order of the number of their appearances. Search for information about said actors/actresses and write a short Wikipedia article about them. For people preferring to edit Wikipedia in English, French, Italian, etc.:Adapt the query below to output the same list, but for actors and actresses who do not have an entry in your language. Add the query below. Create Wikipedia articles in your language. For advanced users:The query below counts the number of appearances, counting actors who appeared several times in the same production (different roles) more than once. Adapt the query to indicate the number of individual productions in which the actor/actress appeared instead of providing the number of appearances. List the adapted query below. Create a list of all actors and actresses who appeared in theatrical productions of Schauspielhaus Zürich in the order of the number of their appearances with an overview which artists have a Wikipedia entry in which language.

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?actor ?actorLabel (count(*) AS ?count)
  WHERE {
  ?prod (wdt:P31/wdt:P279*) wd:Q43099500 ;
        wdt:P272 wd:Q40313234 .
  ?prod wdt:P161 ?actor . 
  MINUS { ?sitelink schema:isPartOf <https://de.wikipedia.org/> ;
     schema:about ?actor . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],de" } .
} 

GROUP BY ?actor ?actorLabel
ORDER BY DESC (?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?actor"):::projected v5("?count") v2("?prod") v4("?sitelink") a1((" ")) c8([https://de.wikipedia.org/]):::iri c13(["#91;AUTO_LANGUAGE#93;,de"]):::literal c3(["wd:Q43099500"]):::iri c5(["wd:Q40313234"]):::iri c11(["bd:serviceParam"]):::iri v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c3 v2 --"wdt:P272"--> c5 v2 --"wdt:P161"--> v3 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v4 --"schema:isPartOf"--> c8 v4 --"schema:about"--> v3 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end bind2[/"count(*)"/] bind2 --as--o v5