query-2425e182514018aeae52dd5f6dc2610c

rq turtle/ttl

title: Authors of works that use software SELECT DISTINCT ?author ?authorLabel ?count WITH { SELECT DISTINCT ?work WHERE { ?work wdt:P4510 ?use .
?use wdt:P1324 [] . } } AS %papers WITH { SELECT ?author (COUNT(DISTINCT ?work) AS ?count) WHERE { INCLUDE %papers ?work wdt:P50 ?author . } GROUP BY ?author HAVING ( ?count > 10) } AS %authors WHERE { INCLUDE %authors SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } GROUP BY ?author ?authorLabel ?count ORDER BY DESC(?count) LIMIT 200

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#>
#title: Authors of works that use software
SELECT DISTINCT ?author ?authorLabel  ?count
WHERE {
   {
  SELECT ?author (COUNT(DISTINCT ?work) AS ?count)  WHERE {
     {
  SELECT DISTINCT ?work WHERE {
    ?work wdt:P4510 ?use .  
    ?use wdt:P1324 [] .
  }
}    ?work wdt:P50 ?author .
  }
  GROUP BY ?author
  HAVING ( ?count > 10)
}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?author ?authorLabel ?count
ORDER BY DESC(?count)
LIMIT 200

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_Informatics/Software/Queries