query-5c611ccf198a686d9dd2d88369b40f67

rq turtle/ttl

Top topics through time

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:AreaChart

PREFIX target: <http://www.wikidata.org/entity/Q24283660>

SELECT
  ?year
  ?works
  ?topic ?topicLabel
WHERE {
   {
  SELECT
    ?year 
    (COUNT(?work) AS ?works)
    ?topic
  WHERE {
     {
  SELECT DISTINCT 
    ?work
  WHERE {
    INCLUDE %researchers 
    ?work wdt:P50 ?researcher ; 
  }
}     {
  SELECT
    (COUNT(?work) AS ?count)
    ?topic
  WHERE {
    INCLUDE %works
    ?work wdt:P921 ?topic .
  }
  GROUP BY ?topic
  ORDER BY DESC(?count)
  LIMIT 5
}    ?work wdt:P921 ?topic ;
          wdt:P577 ?publication_datetime .
    BIND(STR(YEAR(?publication_datetime)) AS ?year)
  }
  GROUP BY ?year ?topic
}  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?year

Query found at