query-ed50696f12ed04a82c97229605c25b9c

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX v: <http://www.wikidata.org/prop/statement/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>

SELECT ?item ?itemLabel ?instance ?instanceLabel (MIN(?imdbAll) AS ?imdb) (MIN(?mojoAll) AS ?mojo) (MIN(?release) AS ?firstRelease) WHERE {
  VALUES ?item {wd:Q9321426 wd:Q17150575 wd:Q18703062 wd:Q18192306 wd:Q20646602 wd:Q19881558 wd:Q19938437 wd:Q18639756 wd:Q18149041 wd:Q3604746 wd:Q19595098 wd:Q18786473 wd:Q19880878 wd:Q21979652 wd:Q20120108 wd:Q12127045 wd:Q17572811 wd:Q18486021 wd:Q19897965 wd:Q16556668 wd:Q19363732 wd:Q21500755 wd:Q21527443}.
  OPTIONAL{?item wdt:P31 ?instance}.
  OPTIONAL{?item wdt:P345 ?imdbAll}.
  OPTIONAL{?item wdt:P1237 ?mojoAll}.
  OPTIONAL{?item p:P577 ?release_statement . ?release_statement psv:P577/wikibase:timePrecision "11"^^xsd:integer . ?release_statement v:P577 ?release}.
  SERVICE wikibase:label {bd:serviceParam wikibase:language "de"}
} 
GROUP BY ?item ?itemLabel ?instanceLabel ?instance
ORDER BY ?instance ?itemLabel

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v10("?firstRelease") v8("?imdb") v4("?imdbAll"):::projected v1("?instance"):::projected v3("?item"):::projected v2("?itemLabel"):::projected v9("?mojo") v5("?mojoAll"):::projected v7("?release"):::projected v6("?release_statement") a1((" ")) c7(["11^^xsd:integer"]):::literal c12(["de"]):::literal c10(["bd:serviceParam"]):::iri bind0[/VALUES ?item/] bind0-->v3 bind00(["wd:Q9321426"]) bind00 --> bind0 bind01(["wd:Q17150575"]) bind01 --> bind0 bind02(["wd:Q18703062"]) bind02 --> bind0 bind03(["wd:Q18192306"]) bind03 --> bind0 bind04(["wd:Q20646602"]) bind04 --> bind0 bind05(["wd:Q19881558"]) bind05 --> bind0 bind06(["wd:Q19938437"]) bind06 --> bind0 bind07(["wd:Q18639756"]) bind07 --> bind0 bind08(["wd:Q18149041"]) bind08 --> bind0 bind09(["wd:Q3604746"]) bind09 --> bind0 bind010(["wd:Q19595098"]) bind010 --> bind0 bind011(["wd:Q18786473"]) bind011 --> bind0 bind012(["wd:Q19880878"]) bind012 --> bind0 bind013(["wd:Q21979652"]) bind013 --> bind0 bind014(["wd:Q20120108"]) bind014 --> bind0 bind015(["wd:Q12127045"]) bind015 --> bind0 bind016(["wd:Q17572811"]) bind016 --> bind0 bind017(["wd:Q18486021"]) bind017 --> bind0 bind018(["wd:Q19897965"]) bind018 --> bind0 bind019(["wd:Q16556668"]) bind019 --> bind0 bind020(["wd:Q19363732"]) bind020 --> bind0 bind021(["wd:Q21500755"]) bind021 --> bind0 bind022(["wd:Q21527443"]) bind022 --> bind0 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P31".-> v1 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P345".-> v4 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:direct/P1237".-> v5 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:P577".-> v6 v6 --"p:statement/value/P577"--> a1 a1 --"wikibase:timePrecision"--> c7 v6 --"p:statement/P577"--> v7 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c10 --"wikibase:language"--> c12 end bind4[/"min(?imdbAll)"/] v4 --o bind4 bind4 --as--o v8 bind5[/"min(?mojoAll)"/] v5 --o bind5 bind5 --as--o v9 bind6[/"min(?release)"/] v7 --o bind6 bind6 --as--o v10