query-e2056f16efb3e9dda3081ad94ebabbfa

rq turtle/ttl

a list of all movies shot in the 60s in Spain…

TODO: in which a black female horse is stolen by a…

left-handed actor…

TODO playing a Portuguese orphan, …

directed by a colorblind German…

TODO who liked sailing, …

and written by a dog-owning wom[a]n from Helsinki

https://www.wikidata.org/wiki/Special:Diff/91950454

SELECT ?movie WHERE { ?movie wdt:P31/wdt:P279 wd:Q11424; wdt:P915/wdt:P17 wd:Q29; wdt:P577 ?date; # TODO shot in the 60s, not published. But how is that modeled? “significant event: principal photography” is occasionally used, but currently a constraint violation. wdt:P161 ?actor; wdt:P57 ?director; wdt:P58 ?writer. FILTER("1960-01-01"^^xsd:dateTime <= ?date && ?date < "1970-01-01"^^xsd:dateTime) ?actor wdt:P552 wd:Q789447. ?director wdt:P31 wd:Q5; wdt:P27 wd:Q183; wdt:P1050/wdt:P279 wd:Q133696. ?writer wdt:P31 wd:Q5; wdt:P1429/(wdt:P31/wdt:P279*)? wd:Q144; wdt:P21 wd:Q6581072; wdt:P19|wdt:P551 wd:Q1757. # TODO meaning of “from”? }

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
# a list of all movies shot in the 60s in Spain…
# TODO: in which a black female horse is stolen by a…
# left-handed actor…
# TODO playing a Portuguese orphan, …
# directed by a colorblind German…
# TODO who liked sailing, …
# and written by a dog-owning wom[a]n from Helsinki
# https://www.wikidata.org/wiki/Special:Diff/91950454
SELECT ?movie WHERE {
  ?movie wdt:P31/wdt:P279* wd:Q11424;
         wdt:P915/wdt:P17 wd:Q29;
         wdt:P577 ?date; # TODO *shot* in the 60s, not published. But how is that modeled? “significant event: principal photography” is occasionally used, but currently a constraint violation.
         wdt:P161 ?actor;
         wdt:P57 ?director;
         wdt:P58 ?writer.
  FILTER("1960-01-01"^^xsd:date <= ?date && ?date < "1970-01-01"^^xsd:dat)
  ?actor wdt:P552 wd:Q789447.
  ?director wdt:P31 wd:Q5;
            wdt:P27 wd:Q183;
            wdt:P1050/wdt:P279* wd:Q133696.
  ?writer wdt:P31 wd:Q5;
          wdt:P1429/(wdt:P31/wdt:P279*)? wd:Q144;
          wdt:P21 wd:Q6581072;
          wdt:P19|wdt:P551 wd:Q1757. # TODO meaning of “from”?
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?actor") v1("?date") v4("?director") v2("?movie"):::projected v5("?writer") a1((" ")) a2((" ")) a3((" ")) a4((" ")) a5((" ")) c25(["wd:Q1757"]):::iri c23(["wd:Q6581072"]):::iri c8(["wd:Q29"]):::iri c15(["wd:Q5"]):::iri c19(["wd:Q133696"]):::iri c5(["wd:Q11424"]):::iri c14(["wd:Q789447"]):::iri c17(["wd:Q183"]):::iri c21(["wd:Q144"]):::iri f0[["'1960-01-01^^xsd:date' <= ?date?date < s1970-01-01^^<http://www.w3.org/2001/XMLSchema#dat>'"]] f0 --> v1 v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c5 v2 --"wdt:P915"--> a2 a2 --"wdt:P17"--> c8 v2 --"wdt:P577"--> v1 v2 --"wdt:P161"--> v3 v2 --"wdt:P57"--> v4 v2 --"wdt:P58"--> v5 v3 --"wdt:P552"--> c14 v4 --"wdt:P31"--> c15 v4 --"wdt:P27"--> c17 v4 --"wdt:P1050"--> a3 a3 --"wdt:P279"--> c19 v5 --"wdt:P31"--> c15 v5 --"wdt:P1429"--> a4 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; a4 --"wdt:P31"--> a5 a5 --"wdt:P279"--> c21 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; end union0r <== or ==> union0l end v5 --"wdt:P21"--> c23 subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; v5 --"wdt:P551"--> c25 end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v5 --"wdt:P19"--> c25 end union1r <== or ==> union1l end