query-9040a4acff9d78dc5d1a6649e264dbdb
Propertiesinstance of (P31)original language of film or TV show (P364)publication date (P577)
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#Odia films released per year
#defaultView:BarChart
SELECT ?year (count(?item) as ?cnt) WHERE{
?item wdt:P31 wd:Q11424 .
?item wdt:P364 wd:Q33810 .
?item wdt:P577 ?publicationdate .
BIND(str(year(?publicationdate)) as ?year)
FILTER(bound(?year))
}
GROUP BY ?year
ORDER BY ?year
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?cnt")
v2("?item"):::projected
v3("?publicationdate")
v4("?year"):::projected
c2(["wd:Q11424"]):::iri
c4(["wd:Q33810"]):::iri
f0[["bound(?year)"]]
f0 --> v4
v2 --"wdt:P31"--> c2
v2 --"wdt:P364"--> c4
v2 --"wdt:P577"--> v3
bind1[/"str(year-from-dateTime(?publicationdate))"/]
v3 --o bind1
bind1 --as--o v4
bind3[/"count(?item)"/]
v2 --o bind3
bind3 --as--o v4