query-e1690c27a26f12c07d8dd4a83df58b72
الممثلون الذين لعبوا نفس الدور أكثر من 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
- https://query.wikidata.org/sparql
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
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ar
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/be-tarask
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ca
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/cs
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/da
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/de
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/en
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/en-gb
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/eo
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/es
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/eu
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/fr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/he
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/hy
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/id
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/it
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ja
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ko
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/lb
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/lt
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ms
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/nl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/pl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/pt-br
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ro
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/ru
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/si
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/sv
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/th
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/tr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/uk
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/vec
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/zh