query-522b000e59a39fd77153ffa2df80f1a0
movie with P973 start with "https://www.artfilm.ch" and in french SELECT DISTINCT ?item ?itemLabel ?réal ?réalLabel ?famLabel WHERE { ?item wdt:P31/wdt:P279* wd:Q2431196; wdt:P57 ?réal. ?item p:P973 ?describestmt. ?describestmt ps:P973 ?decrit. ?describestmt pq:P407 wd:Q150. FILTER STRSTARTS(STR(?decrit), "https://www.artfilm.ch"). ?réal wdt:P734 ?fam. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,it,de". ?item rdfs:label ?itemLabel. ?réal rdfs:label ?réalLabel. ?fam rdfs:label ?famLabel. } } ORDER BY STR(?famLabel)
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 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#>
#movie with P973 start with "https://www.artfilm.ch" and in french
SELECT DISTINCT ?item ?itemLabel ?réal ?réalLabel ?famLabel
WHERE
{
?item wdt:P31/wdt:P279* wd:Q2431196;
wdt:P57 ?réal.
?item p:P973 ?describestmt.
?describestmt ps:P973 ?decrit.
?describestmt pq:P407 wd:Q150.
FILTER STRSTARTS(STR(?decrit), "https://www.artfilm.ch").
?réal wdt:P734 ?fam.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,it,de".
?item rdfs:label ?itemLabel.
?réal rdfs:label ?réalLabel.
?fam rdfs:label ?famLabel.
}
}
ORDER BY STR(?famLabel)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?decrit")
v5("?describestmt")
v6("?fam")
v1("?famLabel"):::projected
v3("?item"):::projected
v7("?itemLabel"):::projected
v4("?réal"):::projected
v8("?réalLabel"):::projected
a1((" "))
c14(["#91;AUTO_LANGUAGE#93;,en,it,de"]):::literal
c4(["wd:Q2431196"]):::iri
c12(["bd:serviceParam"]):::iri
c9(["wd:Q150"]):::iri
f0[["starts-with(str(?decrit),'https://www.artfilm.ch')"]]
f0 --> v2
v3 --"p:direct/P31"--> a1
a1 --"p:direct/P279"--> c4
v3 --"p:direct/P57"--> v4
v3 --"p:P973"--> v5
v5 --"p:statement/P973"--> v2
v5 --"p:qualifier/P407"--> c9
v4 --"p:direct/P734"--> v6
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c12 --"wikibase:language"--> c14
v3 --"rdfs:label"--> v7
v4 --"rdfs:label"--> v8
v6 --"rdfs:label"--> v1
end