query-b01ef40bf787bcf69bb44ddec7d6eb04

rq turtle/ttl

Acteurs dans un film sorti avant leur naissanceActor that are in the distribution of a movie that was published before they were born :

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?actor ?actorLabel ?movie ?movieLabel ?dob ?age WHERE {
  {
    SELECT ?actor ?dob {
        ?dob_node wikibase:timePrecision "11"^^xsd:integer . 
        ?dob_node wikibase:timeValue ?dob . 
        ?actor p:P569/psv:P569 ?dob_node . 
    }
  }
  ?actor wdt:P21 ?genre .
  ?actor wdt:P106 wd:Q33999 .
  ?actor wdt:P27 wd:Q142 .
  ?movie wdt:P161 ?actor .
  ?movie wdt:P577 ?dateMovie .
  BIND(YEAR(?dateMovie)-YEAR(?dob) as ?age) . 
  FILTER(?age < 0) .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?actor"):::projected v8("?age"):::projected v7("?dateMovie") v3("?dob"):::projected v2("?dob_node") v5("?genre") v6("?movie"):::projected a1((" ")) c3(["11^^xsd:integer"]):::literal c15(["bd:serviceParam"]):::iri c17(["#91;AUTO_LANGUAGE#93;,fr"]):::literal c9(["wd:Q33999"]):::iri c11(["wd:Q142"]):::iri f0[["?age < '0^^xsd:integer'"]] f0 --> v8 v2 --"wikibase:timePrecision"--> c3 v2 --"wikibase:timeValue"--> v3 v4 --"p:P569"--> a1 a1 --"p:statement/value/P569"--> v2 v4 --"p:direct/P21"--> v5 v4 --"p:direct/P106"--> c9 v4 --"p:direct/P27"--> c11 v6 --"p:direct/P161"--> v4 v6 --"p:direct/P577"--> v7 bind1[/"year-from-dateTime(?dateMovie) - year-from-dateTime(?dob)"/] v7 --o bind1 v3 --o bind1 bind1 --as--o v8 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c15 --"wikibase:language"--> c17 end