query-8934301f12c2e5cd7fe848aa6f61e79d

rq turtle/ttl

Actors and their films). (P444)review score , (Q11424)film ) and great movies ((P161)cast member Actors ((Q95089)Ginger Rogers (Q100937)Fred Astaire (Q484881)Peter Falk (Q440206)Honeysuckle Weeks (Q589894)Ninotchka (Q246656)Grand Hotel (Q5443)Greta Garbo (Q42786)Audrey Hepburn (Q56016)Katharine Hepburn (Q71206)Bette Davis (Q94123)Jack Lemmon (Q43203)Clint Eastwood (Q172241)The Shawshank Redemption (Q48337)Morgan Freeman (Q23844)George Clooney (Q103876)Peter O'Toole (Q39792)Jack Nicholson (Q159347)Steve McQueen (Q103894)Alec Guinness (Q81328)Harrison Ford (Q95002)William Holden (Q40531)John Wayne (Q83410)Cary Grant (Q251559)The Treasure of the Sierra Madre (Q1137931)The Big Sleep (Q132689)Casablanca (Q16390)Humphrey Bogart (Q71243)Clark Gable

Use at

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 ?actor ?actorLabel ?rankLabel ?film ?filmLabel ?score ?stmtScore
{ 
  # bind the actor
  BIND (wd:Q16390 AS ?actor) .

  # there is a film
  ?film wdt:P31/wdt:P279* wd:Q11424 .

  # film has actor as a cast member
  ?film wdt:P161 ?actor .

  # get the film review score statement
  ?film p:P444 ?stmtScore .
  ?stmtScore ps:P444 ?score .
  # by Rotten Tomatoes
  ?stmtScore pq:P447 wd:Q105584 .
  # determination method is tomato meter
  ?stmtScore pq:P459 wd:Q108403393 .

  # human instead of fictional
  ?actor wdt:P31 wd:Q5 .

  SERVICE wikibase:label {
     bd:serviceParam wikibase:language "en" .
  }
} ORDER BY ?score

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?actor"):::projected v3("?film"):::projected v1("?score"):::projected v4("?stmtScore"):::projected a1((" ")) c10(["wd:Q108403393"]):::iri c15(["en"]):::literal c8(["wd:Q105584"]):::iri c13(["bd:serviceParam"]):::iri c11(["wd:Q5"]):::iri c3(["wd:Q11424"]):::iri bind0[/"'wd:Q16390'"/] bind0 --as--o v2 v3 --"p:direct/P31"--> a1 a1 --"p:direct/P279"--> c3 v3 --"p:direct/P161"--> v2 v3 --"p:P444"--> v4 v4 --"p:statement/P444"--> v1 v4 --"p:qualifier/P447"--> c8 v4 --"p:qualifier/P459"--> c10 v2 --"p:direct/P31"--> c11 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end