query-c7e56f19000d50d415aa49a89b59c2a8
Items with Kinopolis or Cineplex ID
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#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX v: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?film ?filmLabel ?release ?kinopolis ?cineplex WHERE {
{SELECT DISTINCT ?film {{?film wdt:P2970 ?kinopolis} UNION {?film wdt:P3077 ?cineplex}}}
OPTIONAL{?film wdt:P2970 ?kinopolis} OPTIONAL{?film wdt:P3077 ?cineplex} .
OPTIONAL{?film p:P577 ?release_statement . ?release_statement v:P577 ?release . ?release_statement pq:P291 wd:Q183}
SERVICE wikibase:label {bd:serviceParam wikibase:language "de"}
}
ORDER BY DESC(?release)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?cineplex"):::projected
v2("?film"):::projected
v3("?kinopolis"):::projected
v1("?release"):::projected
v5("?release_statement")
c10(["de"]):::literal
c8(["bd:serviceParam"]):::iri
c6(["wd:Q183"]):::iri
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
v2 --"p:direct/P3077"--> v4
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v2 --"p:direct/P2970"--> v3
end
union0r <== or ==> union0l
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P2970".-> v3
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P3077".-> v4
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:P577".-> v5
v5 --"p:statement/P577"--> v1
v5 --"p:qualifier/P291"--> c6
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end