query-e1690c27a26f12c07d8dd4a83df58b72

rq turtle/ttl

الممثلون الذين لعبوا نفس الدور أكثر من 40 سنة Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Herci, kteří hráli stejnou roli s odstupem více než 40 let Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Acteurs qui ont joué le même personnage à plus de 40 ans d’écart Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Attori che hanno interpretato lo stesso ruolo a più di 40 anni di distanza Actors who played the same role more than 40 years apart 40년 이상 같은 역할을 배정받은 배우들 찾아보기 Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Acteurs die dezelfde rol meer dan 40 jaar na elkaar speelden Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Актёр, игравший одну и ту же роль с промежутком больше чем в 40 лет Actors who played the same role more than 40 years apart Skådespelare som spelat samma roll över mer än 40 år Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart Actors who played the same role more than 40 years apart

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 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#>
SELECT DISTINCT ?actor ?actorLabel ?characterLabel ?movie1Label ?movie2Label WHERE {
  ?movie1 p:P161 [
            ps:P161 ?actor;
            pq:P453 ?character
          ];
          wdt:P577 ?movie1Publication.
  ?movie2 p:P161 [
            ps:P161 ?actor;
            pq:P453 ?character
          ];
          wdt:P577 ?movie2Publication.
  MINUS{?movie1 wdt:P31/wdt:P279? wd:Q24856} # Not a series
  MINUS{?movie2 wdt:P31/wdt:P279? wd:Q24856} # Not a series
  FILTER(?character != wd:Q18086706). # Not as "themselves"
  FILTER(?movie1Publication + "P40Y"^^xsd:duration < ?movie2Publication) # 40 years between them
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?actor"):::projected v3("?character") v5("?movie1") v1("?movie1Publication") v6("?movie2") v2("?movie2Publication") a1((" ")) a2((" ")) a3((" ")) a4((" ")) c8(["wd:Q24856"]):::iri c13(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal c11(["bd:serviceParam"]):::iri f0[["?movie1Publication + 'P40Y^^xsd:duration' < ?movie2Publication"]] f0 --> v1 f0 --> v2 f1[["?character != 'wd:Q18086706'"]] f1 --> v3 a1 --"p:statement/P161"--> v4 a1 --"p:qualifier/P453"--> v3 v5 --"p:P161"--> a1 v5 --"p:direct/P577"--> v1 a2 --"p:statement/P161"--> v4 a2 --"p:qualifier/P453"--> v3 v6 --"p:P161"--> a2 v6 --"p:direct/P577"--> v2 subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; v5 --"p:direct/P31"--> a3 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; a3 --"p:direct/P279"--> c8 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; end union0r <== or ==> union0l end end subgraph minus3["MINUS"] style minus3 stroke-width:6px,fill:pink,stroke:red; v6 --"p:direct/P31"--> a4 subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; a4 --"p:direct/P279"--> c8 end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; end union1r <== or ==> union1l end end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end