query-ba9ad52f90fba52dd0fd8e4c44f7eeba

rq turtle/ttl

Propertiesinstance of (P31)platform (P400)publication date (P577)

Use at

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#>
#title:Timeline of games per platform
#defaultView:AreaChart
SELECT (SAMPLE(?year) AS ?year) (COUNT(?_platform) AS ?count) (SAMPLE(?_platformLabel) AS ?platformLabel)  WHERE {
  ?video_game wdt:P31 wd:Q7889.
  ?video_game wdt:P400 ?_platform.
  ?video_game wdt:P577 ?date.
  BIND ( STR(year(?date)) as ?year )
  FILTER(BOUND(?year))
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
                          ?_platform rdfs:label ?_platformLabel.}
}
GROUP BY ?year ?_platform
HAVING (?count > 10)

Query found at