query-abdac13b0ec04364e9cf6d4ebdba4ce1

rq turtle/ttl

Bar chart of all dice and material used per year

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:BarChart
SELECT ?year (COUNT(?_uses) AS ?count) (SAMPLE(?_usesLabel) AS ?_usesLabel) WHERE {
  ?item wdt:P31 wd:Q1643932; # instance of: ttrpg
        wdt:P577 ?_date;   # inception
        wdt:P2283 ?_uses.
  BIND(str(YEAR(?_date)) AS ?year)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
                          ?_uses rdfs:label ?_usesLabel.}
  FILTER(?_date >= "1960-00-00T00:00:00Z"^^xsd:dateTime)
}
GROUP BY ?_usesLabel ?year
HAVING (?count > 0)

Query found at