query-c8f2ce2110489b985ed0b9acf42ef748
Finding humans with a page in English Wikipedia and an ORCID 13:14, 16 June 2023 (UTC)) talk (TrilotatI presume this would be easy for someone who is more clever at using this tool. Thank you. This is a short list of 100 humans with an English Wikipedia article and an ORCID. If they have multiple ORCID each of them may be listed multiple times. You can change the "100" to another number if you want more. filtering by occupation (P106) = researcher (Q1650915) 00:34, 12 July 2023 (UTC)) talk (Trilotat:, thank you for generating this query for me recently. I neglected to thank you and time got away. Can I ask you to edit it so it lists only researchers? Thank you in advance. Fnielsen@
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT
?human ?humanLabel
?orcid
?article
WHERE {
{
SELECT
?human ?orcid ?article
WHERE {
?human wdt:P31 wd:Q5 ;
wdt:P496 ?orcid ;
^schema:about ?article .
?article schema:inLanguage "en" .
}
LIMIT 100 # Change if more humans should be returned
} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Query found at
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2023/06
- https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2023/07
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?article"):::projected
v1("?human"):::projected
v2("?orcid"):::projected
c8(["bd:serviceParam"]):::iri
c2(["wd:Q5"]):::iri
c6(["en"]):::literal
c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal
v1 --"wdt:P31"--> c2
v1 --"wdt:P496"--> v2
v3 --"schema:about"--> v1
v3 --"schema:inLanguage"--> c6
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end