query-001c06cf34f07f121c47ac13d5e08e8c

rq turtle/ttl

title: Dänische Filme SELECT DISTINCT ?item ?itemLabel ?article ?page_title ?year ?copyrightLabel WHERE { ?item wdt:P31 wd:Q11424; wdt:P495 wd:Q35; wdt:P364 wd:Q9035. OPTIONAL { ?gepage schema:about ?item; schema:isPartOf https://da.wikipedia.org/; schema:name ?ge_title. } OPTIONAL { ?depage schema:about ?item; schema:isPartOf https://de.wikipedia.org/; schema:name ?de_title. } OPTIONAL { ?item wdt:P577 ?date. } BIND(YEAR(?date) AS ?year) optional { ?item wdt:P6216 ?copyright. } BIND(IF(BOUND(?depage), ?depage, ?gepage) AS ?article) BIND(IF(BOUND(?de_title), ?de_title, ?ge_title) AS ?page_title) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". } } ORDER BY (?year)

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#>
#title: Dänische Filme
SELECT DISTINCT ?item ?itemLabel ?article ?page_title ?year ?copyrightLabel WHERE {
  ?item wdt:P31 wd:Q11424;
    wdt:P495 wd:Q35;
    wdt:P364 wd:Q9035.
  OPTIONAL {
    ?gepage schema:about ?item;
      schema:isPartOf <https://da.wikipedia.org/>;
      schema:name ?ge_title.
  }
  OPTIONAL {
    ?depage schema:about ?item;
      schema:isPartOf <https://de.wikipedia.org/>;
      schema:name ?de_title.
  }
  OPTIONAL { ?item wdt:P577 ?date. }
  BIND(YEAR(?date) AS ?year)
  optional { ?item wdt:P6216 ?copyright. }
  BIND(IF(BOUND(?depage), ?depage, ?gepage) AS ?article)
  BIND(IF(BOUND(?de_title), ?de_title, ?ge_title) AS ?page_title)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". }
}
ORDER BY (?year)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v9("?article"):::projected v8("?copyright") v7("?date") v6("?de_title") v5("?depage") v4("?ge_title") v3("?gepage") v2("?item"):::projected v10("?page_title"):::projected v8("?year"):::projected c11([https://de.wikipedia.org/]):::iri c4(["wd:Q35"]):::iri c6(["wd:Q9035"]):::iri c15(["bd:serviceParam"]):::iri c9([https://da.wikipedia.org/]):::iri c17(["#91;AUTO_LANGUAGE#93;,da,en"]):::literal c2(["wd:Q11424"]):::iri v2 --"wdt:P31"--> c2 v2 --"wdt:P495"--> c4 v2 --"wdt:P364"--> c6 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."schema:about".-> v2 v3 --"schema:isPartOf"--> c9 v3 --"schema:name"--> v4 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v5 -."schema:about".-> v2 v5 --"schema:isPartOf"--> c11 v5 --"schema:name"--> v6 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P577".-> v7 end bind0[/"year-from-dateTime(?date)"/] v7 --o bind0 bind0 --as--o v8 subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P6216".-> v8 end bind1[/"if(bound(?depage),?depage,?gepage)"/] v5 --o bind1 v3 --o bind1 bind1 --as--o v9 bind2[/"if(bound(?de_title),?de_title,?ge_title)"/] v6 --o bind2 v4 --o bind2 bind2 --as--o v10 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c15 --"wikibase:language"--> c17 end