query-10c1ecc4a893d626f5f9bbfb75f4b3d2

rq turtle/ttl

Propertiesmaintained by WikiProject (P6104)main subject (P921)author (P50)employer (P108)member of (P463)affiliation (P1416)part of (P361)

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#>
#defaultView:Table
SELECT ?count ?organization ?organizationLabel ?sample_author ?sample_authorLabel
WHERE {
   {
  SELECT (count(DISTINCT ?work) as ?count) ?organization (SAMPLE(?author) AS ?sample_author) WHERE {
    ?work wdt:P6104 wd:Q56241615 .
    ?work wdt:P921 ?topic . 
    ?work wdt:P50 ?author .
    ?author ( wdt:P108 | wdt:P463 | wdt:P1416 ) / wdt:P361* ?organization . 
  }
  GROUP BY ?organization ?sample_author
  ORDER BY DESC(?count)
  LIMIT 200
}  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTOLANG],en" . } 
}
GROUP BY ?count ?organization ?organizationLabel ?sample_author ?sample_authorLabel
ORDER BY DESC(?count)

Query found at