query-9013ee4017ee1896c5c27d7cf9290b02
Propertiesemployer (P108)family name (P734)given name (P735)ORCID iD (P496)
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 bd: <http://www.bigdata.com/rdf#>
SELECT distinct ?last_nameLabel ?personLabel ?personDescription ?qid ?orcid
WHERE {
BIND(wd:Q121594 as ?prof).
VALUES(?from) {
(wdt:P108)
}
?person ?from wd:Q129421 ;
?P31 wd:Q5;
wdt:P734 ?last_name;
bind(replace(STR(?person),"http://www.wikidata.org/entity/","") AS ?qid)
OPTIONAL { ?person wdt:P735 ?first_name. }
OPTIONAL { ?person wdt:P496 ?orcid.}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} order by ?last_nameLabel ?first_nameLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?P31")
v9("?first_name")
v2("?first_nameLabel")
v4("?from")
v7("?last_name")
v1("?last_nameLabel"):::projected
v10("?orcid"):::projected
v5("?person")
v3("?prof")
v8("?qid"):::projected
c7(["bd:serviceParam"]):::iri
c2(["wd:Q5"]):::iri
c9(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c1(["wd:Q129421"]):::iri
bind0[/"'wd:Q121594'"/]
bind0 --as--o v3
bind1[/VALUES ?from/]
bind1-->v4
bind10(["wdt:P108"])
bind10 --> bind1
v5 -->v4--> c1
v5 -->v6--> c2
v5 --"wdt:P734"--> v7
bind2[/"replace(str(?person),'http://www.wikidata.org/entity/','')"/]
v5 --o bind2
bind2 --as--o v8
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v5 -."wdt:P735".-> v9
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v5 -."wdt:P496".-> v10
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end