query-58d5b1e65389877ee6d0277ac1b063ca

rq turtle/ttl

TODO

Use at

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

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT distinct ?film ?label_de ?nativeTitle ?itemLabel ?label ?langLabel WHERE {
  ?film wdt:P31 wd:Q11424.
  ?film wdt:P161 wd:Q180338.
  ?film wdt:P577 ?publ.
  ?film wdt:P495 ?country .            # get film's country of origin
  ?country wdt:P37 ?official_lang .    # get country's official language
  ?official_lang  wdt:P424 ?langcode . # get language code for the language
  OPTIONAL { ?official_lang rdfs:label ?langLabel . filter (lang(?langLabel) = ?langcode) }
                                       # for this example, get the label of the language

  OPTIONAL { ?film wdt:P1705 ?nativeTitle . filter(lang(?nativeTitle)=?langcode) }
                                       # get the native title  filtered by the language code

  OPTIONAL { ?film rdfs:label ?itemLabel . filter (lang(?itemLabel) = ?langcode) }
                                       # get the item Label filtered by the language code

                                       # coalesce will choose the first valid value as ?label
  bind(coalesce(?nativeTitle, ?itemLabel) as ?label)
  OPTIONAL { ?film rdfs:label ?label_de filter (lang(?label_de) = "de")}.
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2018/12