query-efc375049e45ac44797a2bdb591f3652

rq turtle/ttl

Top designers through years

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:AreaChart
SELECT
  ?year
  ?works
  ?designer ?designerLabel
WHERE {
   {
  SELECT
    ?year 
    (COUNT(?work) AS ?works)
    ?designer
  WHERE {
     {
  SELECT
    (COUNT(?work) AS ?count)
    ?designer
  WHERE {
    ?work wdt:P2739 / wdt:P287 ?designer .
  }
  GROUP BY ?designer
  ORDER BY DESC(?count)
  LIMIT 5
}    ?work wdt:P2739 / wdt:P287 ?designer ;
          wdt:P577 ?publication_datetime .
    BIND(STR(YEAR(?publication_datetime)) AS ?year)
  }
  GROUP BY ?year ?designer
}  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?year

Query found at

• https://www.wikidata.org/wiki/Wikidata:Synia:typeface-index