query-73bdfb76b92f0659d909d658adf98ad9
films connus de Wikidata diffusés en VOD par artfilm.ch SELECT DISTINCT ?film ?filmLabel (GROUP_CONCAT(DISTINCT(?réalLabel); separator=", ") as ?réals) ?duree (MIN(?date) as ?oldest_date) ?URL WHERE { ?film p:P3301 ?artfilm. ?artfilm ps:P3301 ?artfilmCH; pq:P2699 ?URL. FILTER STRSTARTS(STR(?URL), "https://www.artfilm.ch"). OPTIONAL {?film wdt:P2047 ?duree.} OPTIONAL {?film wdt:P57 ?réal.} OPTIONAL {?film wdt:P577 ?date.} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,it,es". ?réal rdfs:label ?réalLabel. ?film rdfs:label ?filmLabel. } } GROUP BY ?film ?filmLabel ?duree ?URL ORDER BY ?oldest_date
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#films connus de Wikidata diffusés en VOD par artfilm.ch
SELECT DISTINCT ?film ?filmLabel (GROUP_CONCAT(DISTINCT(?réalLabel); separator=", ") as ?réals) ?duree (MIN(?date) as ?oldest_date) ?URL
WHERE
{
?film p:P3301 ?artfilm.
?artfilm ps:P3301 ?artfilmCH;
pq:P2699 ?URL.
FILTER STRSTARTS(STR(?URL), "https://www.artfilm.ch").
OPTIONAL {?film wdt:P2047 ?duree.}
OPTIONAL {?film wdt:P57 ?réal.}
OPTIONAL {?film wdt:P577 ?date.}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,it,es".
?réal rdfs:label ?réalLabel.
?film rdfs:label ?filmLabel.
}
}
GROUP BY ?film ?filmLabel ?duree ?URL
ORDER BY ?oldest_date
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?URL"):::projected
v4("?artfilm")
v5("?artfilmCH")
v8("?date"):::projected
v6("?duree"):::projected
v3("?film"):::projected
v10("?filmLabel"):::projected
v12("?oldest_date")
v7("?réal")
v9("?réalLabel"):::projected
v11("?réals")
c9(["bd:serviceParam"]):::iri
c11(["#91;AUTO_LANGUAGE#93;,en,de,it,es"]):::literal
f0[["starts-with(str(?URL),'https://www.artfilm.ch')"]]
f0 --> v2
v3 --"p:P3301"--> v4
v4 --"p:statement/P3301"--> v5
v4 --"p:qualifier/P2699"--> v2
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."p:direct/P2047".-> v6
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v3 -."p:direct/P57".-> v7
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v3 -."p:direct/P577".-> v8
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c9 --"wikibase:language"--> c11
v7 --"rdfs:label"--> v9
v3 --"rdfs:label"--> v10
end
bind3[/"?réalLabel"/]
v9 --o bind3
bind3 --as--o v11
bind4[/"min(?date)"/]
v8 --o bind4
bind4 --as--o v12