query-b6a4a10ae08c137639104b80059a4d4b

PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel (group_concat(distinct ?publication_date;separator="; ") as ?pd) (group_concat(distinct ?imdb_code;separator="; ") as ?imdb) (GROUP_CONCAT(distinct ?directorLabel;separator="; ") AS ?directors) (GROUP_CONCAT(distinct ?screenwriterLabel;separator="; ") AS ?screenwriter) 
WHERE {
 SERVICE wikibase:mwapi
 {
   bd:serviceParam wikibase:api "Search" .
   bd:serviceParam wikibase:endpoint "www.wikidata.org" .
   bd:serviceParam mwapi:srnamespace "0" .
   bd:serviceParam mwapi:srsearch "haswbstatement:P31=Q11424 inlabel:'three'@en" .
   ?item wikibase:apiOutputItem mwapi:title.
 }
  ?item wdt:P577 ?publication_date. 
  FILTER("1996-12-31"^^xsd:date < ?publication_date &&
         ?publication_date < "1998-00-00"^^xsd:dat)
  OPTIONAL {?item wdt:P345 ?imdb_code .}
  OPTIONAL {?item wdt:P57 ?director .}
  OPTIONAL {?item wdt:P58 ?screenwriter .}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,it,es,de,fr,hu,ro" . 
                            ?item rdfs:label ?itemLabel .
                            ?director rdfs:label ?directorLabel .
                            ?screenwriter rdfs:label ?screenwriterLabel.} 
} group by ?item ?itemLabel

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?director") v7("?directorLabel"):::projected v11("?directors") v10("?imdb") v3("?imdb_code"):::projected v2("?item"):::projected v6("?itemLabel"):::projected v9("?pd") v1("?publication_date"):::projected v12("?screenwriter") v8("?screenwriterLabel"):::projected c8(["www.wikidata.org"]):::literal c21(["#91;AUTO_LANGUAGE#93;,en,it,es,de,fr,hu,ro"]):::literal c12(["haswbstatement:P31=Q11424 inlabel:'three'@en"]):::literal c10(["0"]):::literal c4(["bd:serviceParam"]):::iri c6(["Search"]):::literal c14(["mwapi:title"]):::iri f0[["'1996-12-31^^xsd:date' < ?publication_date?publication_date < s1998-00-00^^<http://www.w3.org/2001/XMLSchema#dat>'"]] f0 --> v1 subgraph s1["http://wikiba.se/ontology#mwapi"] style s1 stroke-width:4px; c4 --"mwapi:api"--> c6 c4 --"mwapi:endpoint"--> c8 c4 --"mwapi:srnamespace"--> c10 c4 --"mwapi:srsearch"--> c12 v2 --"mwapi:apiOutputItem"--> c14 end v2 --"wdt:P577"--> v1 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P345".-> v3 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P57".-> v4 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P58".-> v12 end subgraph s2["http://wikiba.se/ontology#label"] style s2 stroke-width:4px; c4 --"mwapi:language"--> c21 v2 --"rdfs:label"--> v6 v4 --"rdfs:label"--> v7 v12 --"rdfs:label"--> v8 end bind5[/"?publication_date"/] v1 --o bind5 bind5 --as--o v9 bind6[/"?imdb_code"/] v3 --o bind6 bind6 --as--o v10 bind7[/"?directorLabel"/] v7 --o bind7 bind7 --as--o v11 bind8[/"?screenwriterLabel"/] v8 --o bind8 bind8 --as--o v12