7,354
edits
Project:SPARQL/examples: Difference between revisions
→Admin
(→People) |
(→Admin) |
||
| Line 935: | Line 935: | ||
} | } | ||
ORDER BY ?personLabel | ORDER BY ?personLabel | ||
</sparql> | |||
===People who have a spouse statement and - optionally - marriage date statements for checking if there is any misalignment with 'Spouse not in wikibase' statements=== | |||
<sparql tryit="1"> | |||
# people who have a spouse statement and - optionally - marriage date statements for checking if there is any misalignment with 'Spouse not in wikibase' statements | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | |||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | |||
PREFIX bnwdv: <https://beyond-notability.wikibase.cloud/value/> | |||
PREFIX bnwdt: <https://beyond-notability.wikibase.cloud/prop/direct/> | |||
PREFIX bnp: <https://beyond-notability.wikibase.cloud/prop/> | |||
PREFIX bnps: <https://beyond-notability.wikibase.cloud/prop/statement/> | |||
PREFIX bnpq: <https://beyond-notability.wikibase.cloud/prop/qualifier/> | |||
SELECT ?person ?personLabel ?spouse ?spouseLabel ?edtfmarriagespouse ?edtfmarriagespouseLabel ?PITmarriagespouse ?PITmarriagespouseLabel WHERE { | |||
?person bnwdt:P41 ?spouse . | |||
OPTIONAL {?person bnp:P132 ?edtfmarriagestatement . | |||
?edtfmarriagestatement bnps:P132 ?edtfmarriagedate . | |||
?edtfmarriagestatement bnpq:P41 ?edtfmarriagespouse .} | |||
OPTIONAL {?person bnp:P130 ?PITmarriagestatement . | |||
?PITmarriagestatement bnps:P130 ?PITmarriagedate . | |||
?PITmarriagestatement bnpq:P41 ?PITmarriagespouse .} | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". | |||
} | |||
} | |||
ORDER BY DESC(?edtfmarriagespouseLabel) DESC(?PITmarriagespouseLabel) | |||
</sparql> | </sparql> | ||