query-ac9218d5679992fee3303818903ca0dc

rq turtle/ttl

title: People with a GitHub account AND an ORCID AND at least one publication SELECT DISTINCT ?author ?authorLabel ?authorDescription ?github ?orcid ?count

WITH { SELECT ?author ?github ?orcid (count(?work) as ?count) WHERE { ?author wdt:P2037 ?github . ?author wdt:P496 ?orcid . ?work wdt:P50 ?author. } GROUP BY ?author ?github ?orcid ORDER BY DESC(?count) LIMIT 5000 } AS %result WHERE { INCLUDE %result

SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . } } ORDER BY DESC(?count)

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: People with a GitHub account AND an ORCID AND at least one publication
SELECT DISTINCT ?author ?authorLabel ?authorDescription ?github ?orcid ?count

WHERE {
   {
  SELECT
    ?author ?github ?orcid
    (count(?work) as ?count)
  WHERE {
    ?author wdt:P2037 ?github .
    ?author wdt:P496 ?orcid . 
    ?work wdt:P50 ?author.
  }
  GROUP BY ?author ?github ?orcid
  ORDER BY DESC(?count)
  LIMIT 5000
}          
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . } 
}
ORDER BY DESC(?count)

Query found at

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