query-45df2989ea2a4b7d3db25d845d53c224

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 Hints: as its source.Repertoire of Schauspielhaus ZürichWhen adding the "based on" statement, make sure that you indicate the (the Q numbers represent the order in which the items were ingested into Wikidata).The entries for Schauspielhaus Zürich start around Q47404135 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). Can you modify the query to only include items which were performed at Schauspielhaus Zürich? – Add your query below the sample query.

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
  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-Atelier_2018
• https://www.wikidata.org/wiki/User:Beat_Estermann/WD_Intro_Swiss_National_Library_2018