query-eeba6753994a527a1b9ffef4de5838f9

rq turtle/ttl

TODO

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 p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:Timeline
# use the earliest publication date in case a film has multiple publication dates, e.g. in different markets
# (and I’m sure the Titanic film was also re-released theatrically, and maybe somebody added that as a statement too)
SELECT ?film ?filmLabel ?filmPublished
WHERE {
   {
  SELECT ?film (MIN(?filmPublished_) AS ?filmPublished) WHERE {
    ?film wdt:P31/wdt:P279* wd:Q11424;
          p:P161/ps:P161 wd:Q38111;
          wdt:P577 ?filmPublished_.
  }
  GROUP BY ?film
}
   {
  SELECT (MIN(?titanicPublished_) AS ?titanicPublished) WHERE {
    wd:Q44578 wdt:P577 ?titanicPublished_.
  }
}
  FILTER(?filmPublished < ?titanicPublished)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Query found at

• https://www.wikidata.org/wiki/User:TweetsFactsAndQueries/Wikimedia_Hackathon_2021_Data_Challenge/11.Showcase_a_timeline_of_the_films_that_Leonardo_DiCaprio_has_cast_in_before_the_movie_Titanic(1997)%3F