User:TweetsFactsAndQueries/Queries/we have more work to do

Originally written somewhere between 2016-2018 (don’t really remember, I dug it out from my browser history). Not finished and therefore not published elsewhere yet. Reference: Special:Diff/91950454

# 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”?
}
Try it!