query-d44784469c89af8e5aa2905356ab0114

rq turtle/ttl

BubbleChart (Q24515280)Functions:  main subject (P921),  author (P50)Properties:  Joerg Bewersdorf (Q49516549),  Stéphane Pagès (Q96210212),  Hagan Bayley (Q5638525),  Denise Kirschner (Q88797604),  Virginie Rozot (Q88590244),  Gregory Hannon (Q55101059),  Maddy Parsons (Q30004330),  Fabian J. Theis (Q39049575),  Chris Sander (Q5107972),  Michael Roukes (Q59674360),  Assaf Zaritsky (Q59679079),  Adrie Jc Steyn (Q59830751)Items:

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Title:Publications and their topics
#defaultView:BubbleChart
SELECT DISTINCT ?topic ?topicLabel (COUNT(?leapauthor) AS ?counts)  WHERE {
   VALUES ?leapauthor {wd:Q59830751 wd:Q59679079 wd:Q59679079 wd:Q59674360 wd:Q5107972 wd:Q39049575 wd:Q30004330 wd:Q55101059 wd:Q88590244 wd:Q88797604 wd:Q5638525 wd:Q96210212 wd:Q49516549}

  ?publication wdt:P50 ?leapauthor ;
               wdt:P921 ?topic .  

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?topic ?topicLabel
ORDER BY desc(?counts)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?counts") v2("?leapauthor"):::projected v3("?publication") v4("?topic"):::projected c4(["bd:serviceParam"]):::iri c6(["#91;AUTO_LANGUAGE#93;,en"]):::literal bind0[/VALUES ?leapauthor/] bind0-->v2 bind00(["wd:Q59830751"]) bind00 --> bind0 bind01(["wd:Q59679079"]) bind01 --> bind0 bind02(["wd:Q59679079"]) bind02 --> bind0 bind03(["wd:Q59674360"]) bind03 --> bind0 bind04(["wd:Q5107972"]) bind04 --> bind0 bind05(["wd:Q39049575"]) bind05 --> bind0 bind06(["wd:Q30004330"]) bind06 --> bind0 bind07(["wd:Q55101059"]) bind07 --> bind0 bind08(["wd:Q88590244"]) bind08 --> bind0 bind09(["wd:Q88797604"]) bind09 --> bind0 bind010(["wd:Q5638525"]) bind010 --> bind0 bind011(["wd:Q96210212"]) bind011 --> bind0 bind012(["wd:Q49516549"]) bind012 --> bind0 v3 --"wdt:P50"--> v2 v3 --"wdt:P921"--> v4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c4 --"wikibase:language"--> c6 end bind2[/"count(?leapauthor)"/] v2 --o bind2 bind2 --as--o v5