query-d350b198130da35014d7b3a3b58a3d4e

rq turtle/ttl

Schauspielhaus Productions without a “based on” statement). download the Schauspielhaus Repertoire in Excel format, which contains information about the author of the work (Repertoire of Schauspielhaus ZürichUse the example query below to identify performing arts productions which do not have a "based on" statement to indicate the literary work they were based on. Complement the statement based on the Hint: as its source.Repertoire of Schauspielhaus ZürichWhen adding the "based on" statement, make sure that you indicate the For advanced learners:Can you track the advancement of the work of your colleagues? – Run your query at different points in time and report the item count over time (create a small table below the sample queries).

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel
WHERE 
{
  ?item wdt:P31/wdt:P279* wd:Q43099500.   # performing arts production
  ?item wdt:P276 wd:Q39918282.            # location: Main stage of Schauspielhaus Zürich
  MINUS { ?item wdt:P144 [] }   # exclude if there is a "based on" statement
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,fr,it". }
}

Query found at

• https://www.wikidata.org/wiki/User:Beat_Estermann/WD-Intro-2019-05-13