SPARQL Examples: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
PREFIX rlwdt: <https://riga-literata.wikibase.cloud/prop/direct/> | PREFIX rlwdt: <https://riga-literata.wikibase.cloud/prop/direct/> | ||
SELECT ?person ?personLabel ?genderLabel ?birthdate ?birthplaceLabel ?deathdate ?deathplaceLabel ?qid ?viaf ?lnc10 | SELECT ?person ?personLabel ?genderLabel ?birthdate ?birthplaceLabel ?deathdate ?deathplaceLabel ?worklocationLabel ?qid ?viaf ?lnc10 | ||
WHERE | WHERE | ||
{ | { | ||
| Line 13: | Line 13: | ||
OPTIONAL { ?person rlwdt:P19 ?deathdate.} | OPTIONAL { ?person rlwdt:P19 ?deathdate.} | ||
OPTIONAL { ?person rlwdt:P21 ?deathplace.} | OPTIONAL { ?person rlwdt:P21 ?deathplace.} | ||
OPTIONAL { ?person rlwdt:P31 ?worklocation.} | |||
OPTIONAL { ?person rlwdt:P6 ?qid.} | OPTIONAL { ?person rlwdt:P6 ?qid.} | ||
OPTIONAL { ?person rlwdt:P30 ?viaf.} | OPTIONAL { ?person rlwdt:P30 ?viaf.} | ||
Revision as of 15:06, 17 January 2023
All persons with all properties
PREFIX rlwd: <https://riga-literata.wikibase.cloud/entity/>
PREFIX rlwdt: <https://riga-literata.wikibase.cloud/prop/direct/>
SELECT ?person ?personLabel ?genderLabel ?birthdate ?birthplaceLabel ?deathdate ?deathplaceLabel ?worklocationLabel ?qid ?viaf ?lnc10
WHERE
{
?person rlwdt:P1 rlwd:Q6.
OPTIONAL { ?person rlwdt:P15 ?gender.}
OPTIONAL { ?person rlwdt:P18 ?birthdate.}
OPTIONAL { ?person rlwdt:P20 ?birthplace.}
OPTIONAL { ?person rlwdt:P19 ?deathdate.}
OPTIONAL { ?person rlwdt:P21 ?deathplace.}
OPTIONAL { ?person rlwdt:P31 ?worklocation.}
OPTIONAL { ?person rlwdt:P6 ?qid.}
OPTIONAL { ?person rlwdt:P30 ?viaf.}
OPTIONAL { ?person rlwdt:P4 ?lnc10.}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,[AUTO_LANGUAGE]". }
}