query-9013ee4017ee1896c5c27d7cf9290b02

rq turtle/ttl

Propertiesemployer (P108)family name (P734)given name (P735)ORCID iD (P496)

Use at

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