query-4020ba17a12efbdb5f58f7ecbd84fe2e

rq turtle/ttl

Indian Biographical films, 266 items @ 02 AUG 2020 SELECT ?item ?wikis ?itemLabel ?subtitle ?langLabel (GROUP_CONCAT(DISTINCT ?year; SEPARATOR = ", ") AS ?released) ?directorLabel ?composerLabel ?basedonLabel WHERE{ ?item wdt:P31 wd:Q11424 . ?item wdt:P136 wd:Q645928. ?item wdt:P495 wd:Q668. OPTIONAL { ?item wikibase:sitelinks ?wikis. } #count sitelinks OPTIONAL { ?item wdt:P577 ?date . BIND(YEAR(?date) as ?year) } OPTIONAL { ?item wdt:P1680 ?subtitle } OPTIONAL { ?item wdt:P364 ?lang } OPTIONAL { ?item wdt:P144 ?basedon } OPTIONAL { ?item wdt:P57 ?director } OPTIONAL { ?item wdt:P86 ?composer } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?item ?itemLabel ?subtitle ?langLabel ?directorLabel ?composerLabel ?wikis ?basedonLabel ORDER BY DESC(?released)

Use at

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#>
# Indian Biographical films, 266 items @ 02 AUG 2020
SELECT
?item ?wikis ?itemLabel ?subtitle ?langLabel (GROUP_CONCAT(DISTINCT ?year; SEPARATOR = ", ") AS ?released) ?directorLabel ?composerLabel ?basedonLabel
WHERE{
    ?item wdt:P31 wd:Q11424 .
    ?item wdt:P136 wd:Q645928.
 ?item wdt:P495 wd:Q668.
  OPTIONAL { ?item wikibase:sitelinks ?wikis. }  #count sitelinks
  OPTIONAL { ?item wdt:P577 ?date . BIND(YEAR(?date) as ?year) }
  OPTIONAL { ?item wdt:P1680 ?subtitle }
  OPTIONAL { ?item wdt:P364 ?lang }
  OPTIONAL { ?item wdt:P144 ?basedon }
  OPTIONAL { ?item wdt:P57 ?director }
  OPTIONAL { ?item wdt:P86 ?composer }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
 GROUP BY ?item ?itemLabel ?subtitle ?langLabel ?directorLabel ?composerLabel ?wikis ?basedonLabel
ORDER BY DESC(?released)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v8("?basedon") v10("?composer") v4("?date") v9("?director") v2("?item"):::projected v7("?lang") v11("?released") v6("?subtitle"):::projected v3("?wikis"):::projected v5("?year"):::projected c15(["bd:serviceParam"]):::iri c6(["wd:Q668"]):::iri c17(["#91;AUTO_LANGUAGE#93;,en"]):::literal c2(["wd:Q11424"]):::iri c4(["wd:Q645928"]):::iri v2 --"wdt:P31"--> c2 v2 --"wdt:P136"--> c4 v2 --"wdt:P495"--> c6 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wikibase:sitelinks".-> v3 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P577".-> v4 bind0[/"year-from-dateTime(?date)"/] v4 --o bind0 bind0 --as--o v5 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P1680".-> v6 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P364".-> v7 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P144".-> v8 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P57".-> v9 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P86".-> v10 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c15 --"wikibase:language"--> c17 end bind2[/"?year"/] v5 --o bind2 bind2 --as--o v11