query-0dbd45d6630dd81d098d1e89659757ab

Tagishsimon

Use at

https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#defaultView:BarChart
SELECT ?part (COUNT(*) AS ?counts) (STR(YEAR(?pit)) AS ?year) 
WHERE 
{
  ?item wdt:P31 wd:Q7604686.
  ?item wdt:P179 ?part.
  ?part wdt:P1001 wd:Q25;
        wdt:P585 ?pit.
}
GROUP BY ?part ?partLabel ?pit

Query found at

https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2020/10

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?counts") v1("?item") v2("?part"):::projected v3("?pit"):::projected v5("?year") c2(["wd:Q7604686"]):::iri c5(["wd:Q25"]):::iri v1 --"wdt:P31"--> c2 v1 --"wdt:P179"--> v2 v2 --"wdt:P1001"--> c5 v2 --"wdt:P585"--> v3 bind1[/"count(*)"/] bind1 --as--o v4 bind2[/"str(year-from-dateTime(?pit))"/] v3 --o bind2 bind2 --as--o v5