query-19a3b7bcb4eb1b3b3f236b6140a518d8
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
#memorable tree - by year
#defaultView:BarChart
SELECT DISTINCT ?year (count(?year) AS ?pocet)
WHERE
{
?item wdt:P31 wd:Q811534 .
?item wdt:P17 wd:Q213 .
?item wdt:P677 ?usop .
?item p:P31/pq:P580 ?datum .
BIND( str(year(?datum)) as ?year ).
}
group by ?year
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?datum")
v1("?item")
v5("?pocet")
v2("?usop")
v4("?year"):::projected
a1((" "))
c2(["wd:Q811534"]):::iri
c4(["wd:Q213"]):::iri
v1 --"p:direct/P31"--> c2
v1 --"p:direct/P17"--> c4
v1 --"p:direct/P677"--> v2
v1 --"p:P31"--> a1
a1 --"p:qualifier/P580"--> v3
bind0[/"str(year-from-dateTime(?datum))"/]
v3 --o bind0
bind0 --as--o v4
bind2[/"count(?year)"/]
v4 --o bind2
bind2 --as--o v5