579
edits
Project:SPARQL/examples: Difference between revisions
→BN Men in Wikidata
(→IDs) |
|||
| Line 2,937: | Line 2,937: | ||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | ||
SELECT distinct ?person ?personLabel ?wikidata ?wd_dob ?wd_dod ?odnb_url | SELECT distinct ?person ?personLabel ?wikidata ?whos_who ?wd_dob ?wikipedia ?wd_dod ?odnb_url ?wd_statements | ||
WHERE { | WHERE { | ||
| Line 2,963: | Line 2,963: | ||
FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/') | FILTER (SUBSTR(str(?wikipedia), 1, 25) = 'https://en.wikipedia.org/') | ||
} | } | ||
optional { ?wikidata wdt:P4789 ?whos . | |||
bind(iri(concat("https://www.ukwhoswho.com/view/article/oupww/whoswho/", ?whos)) as ?whos_who) . | |||
} # P4789 Who's Who | |||
optional { ?wikidata wdt:P569 ?wd_dob . } #date of birth on Wikidata P569 | optional { ?wikidata wdt:P569 ?wd_dob . } #date of birth on Wikidata P569 | ||
optional { ?wikidata wdt:P570 ?wd_dod . } #date of death on Wikidata P570 | optional { ?wikidata wdt:P570 ?wd_dod . } #date of death on Wikidata P570 | ||