query-47bc714e05dbf508d4fad42383b60a2b

rq turtle/ttl

actors or actresses who have won an Oscar (Acadamy Award) for playing an Oscar winner SELECT DISTINCT ?actorA ?actorALabel ?movie ?movieLabel ?actorB ?actorBLabel WHERE { ?actorA wdt:P166/wdt:P31 wd:Q19020. ?award wdt:P31 wd:Q19020. ?actorB p:P166 ?awardStatement. ?awardStatement ps:P166 ?award. #put a comment in front of the line below to show all oscar winners portait by oscar winners ?awardStatement pq:P1686 ?movie. ?movie p:P161 ?castStatement. ?castStatement ps:P161 ?actorB. ?castStatement pq:P453 ?actorA. FILTER (?actorA != ?actorB) #this line is only in here to filter out actors/actresses who play themselves when the condition is removed that the Oscar had to be won for the same movie

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

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 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#>
#actors or actresses who have won an Oscar (Acadamy Award) for playing an Oscar winner
SELECT DISTINCT ?actorA ?actorALabel ?movie ?movieLabel ?actorB ?actorBLabel WHERE {
    ?actorA wdt:P166/wdt:P31 wd:Q19020.
    ?award wdt:P31 wd:Q19020.
    ?actorB p:P166 ?awardStatement.
    ?awardStatement ps:P166 ?award.
    #put a comment in front of the line below to show all oscar winners portait by oscar winners
    ?awardStatement pq:P1686 ?movie.
    ?movie p:P161 ?castStatement.
    ?castStatement ps:P161 ?actorB.
    ?castStatement pq:P453 ?actorA.
    FILTER (?actorA != ?actorB) #this line is only in here to filter out actors/actresses who play themselves when the condition is removed that the Oscar had to be won for the same movie

    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

• https://www.wikidata.org/wiki/User:Frog23/My_Queries