590
edits
Project:SPARQL/admin: Difference between revisions
→People who have a spouse statement and - optionally - marriage date statements for checking if there is any misalignment with 'Spouse not in wikibase' statements
mNo edit summary |
|||
| Line 106: | Line 106: | ||
} | } | ||
ORDER BY DESC(?edtfmarriagespouseLabel) DESC(?PITmarriagespouseLabel) | ORDER BY DESC(?edtfmarriagespouseLabel) DESC(?PITmarriagespouseLabel) | ||
</sparql> | |||
=== Married names and Marriage dates === | |||
<sparql tryit="1"> | |||
#title:Query for married name/married dates discrepancies. | |||
# some women have a married name but no marriage date, or vice versa. This query should help with checking for the missing information... | |||
# most have very few statements and/or are just "Mrs". But there are some with 20+ statements. | |||
# so there's a FILTER statements line that can be adjusted; it's currently at 10 | |||
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/> | |||
PREFIX bnpsv: <https://beyond-notability.wikibase.cloud/prop/statement/value/> | |||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | |||
SELECT distinct ?person ?personLabel ?statements ?married_name ?married_in | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 ; | |||
wikibase:statements ?statements . | |||
FILTER (?statements > 10) . | |||
OPTIONAL {?person bnwdt:P141 ?married_name .} #look for married name (bnwdt:P130 | bnwdt: P132) | |||
optional {?person (bnwdt:P130 | bnwdt:P132) ?married_in . } | |||
FILTER ( | |||
(NOT EXISTS { ?person bnwdt:P141 ?marriedname .} && EXISTS { ?person (bnwdt:P130 | bnwdt:P132 ) ?married . } ) | |||
|| | |||
(EXISTS { ?person bnwdt:P141 ?marriedname .} && NOT EXISTS { ?person (bnwdt:P130 | bnwdt:P132 ) ?married . } ) | |||
) . | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb". | |||
} | |||
} # /where | |||
ORDER BY ?personLabel | |||
</sparql> | </sparql> | ||