query-f53fd0aed8be91083a5e2429136e8d5d

rq turtle/ttl

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:P973 ?describes; wdt:P57 ?réal FILTER STRSTARTS(STR(?describes), "https://www.artfilm.ch"). ?item p:P973 ?describes. ?describes ps:P973 ?decrit. ?decrit pq:P407 wd:Q150. ?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

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:P973 ?describes;
        wdt:P57 ?réal
  FILTER STRSTARTS(STR(?describes), "https://www.artfilm.ch").
  ?item p:P973 ?describes.
  ?describes ps:P973 ?decrit.
  ?decrit pq:P407 wd:Q150.
  ?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; v5("?decrit") v2("?describes") v6("?fam") v1("?famLabel"):::projected v3("?item"):::projected v7("?itemLabel"):::projected v4("?réal"):::projected v8("?réalLabel"):::projected a1((" ")) c15(["#91;AUTO_LANGUAGE#93;,en,it,de"]):::literal c4(["wd:Q2431196"]):::iri c13(["bd:serviceParam"]):::iri c10(["wd:Q150"]):::iri f0[["starts-with(str(?describes),'https://www.artfilm.ch')"]] f0 --> v2 v3 --"p:direct/P31"--> a1 a1 --"p:direct/P279"--> c4 v3 --"p:direct/P973"--> v2 v3 --"p:direct/P57"--> v4 v3 --"p:P973"--> v2 v2 --"p:statement/P973"--> v5 v5 --"p:qualifier/P407"--> c10 v4 --"p:direct/P734"--> v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 v3 --"rdfs:label"--> v7 v4 --"rdfs:label"--> v8 v6 --"rdfs:label"--> v1 end