query-af8732b75474851a41fe76e8fca52c64

rq turtle/ttl

title: items with a GitHub username AND an ORCID AND a site link in the Wikimedia platform SELECT DISTINCT ?item ?itemLabel ?github_user ?orcid ?sitelinks WITH { SELECT ?item ?github_user ?sitelinks WHERE { ?item wdt:P2037 ?github_user . ?item wikibase:sitelinks ?sitelinks . } } AS %github WHERE { INCLUDE %github ?item wdt:P496 ?orcid . ?item rdfs:label ?itemLabel . FILTER(LANG(?itemLabel) = "en"). FILTER(?sitelinks > 0 ) } ORDER BY DESC(?sitelinks)

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
#title: items with a GitHub username AND an ORCID AND a site link in the Wikimedia platform
SELECT DISTINCT ?item ?itemLabel ?github_user ?orcid ?sitelinks
WHERE {
   {
  SELECT ?item ?github_user ?sitelinks WHERE {
    ?item wdt:P2037 ?github_user .
    ?item wikibase:sitelinks ?sitelinks .
  }
}  ?item wdt:P496 ?orcid .
  ?item rdfs:label ?itemLabel .
  FILTER(LANG(?itemLabel) = "en").
  FILTER(?sitelinks > 0
        )
}
ORDER BY DESC(?sitelinks)

Query found at

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