579
edits
Project:SPARQL/examples: Difference between revisions
→Statements that contain both a date *and* an unknown value date
| Line 1,839: | Line 1,839: | ||
ORDER BY ?itemLabel ?main_label ?qualLabel ?subLabel ?date_prop | ORDER BY ?itemLabel ?main_label ?qualLabel ?subLabel ?date_prop | ||
</sparql> | |||
=== [WIP] Women with no dates=== | |||
<sparql tryit="1"> | |||
# Query for women with no dates | |||
# WIP: at present this includes <unknown value> dates as well as no dates at all [eg Miss Keyser Q2622] | |||
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 (count(?date_value) as ?count) | |||
WHERE { | |||
{ # main dates | |||
?person bnwdt:P3 bnwd:Q3 . # women | |||
optional { | |||
?person ?p ?s . | |||
?s ?date_prop ?wdv . | |||
?wdv wikibase:timeValue ?date_value . } | |||
} # /main dates | |||
UNION | |||
{ # qualifier dates | |||
?person bnwdt:P3 bnwd:Q3 . | |||
optional { | |||
?person ?p ?s . | |||
?s ?date_prop ?pqv . | |||
?pqv wikibase:timeValue ?date_value. } | |||
} # /qual dates | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb,en". } | |||
} # /where | |||
group by ?person ?personLabel | |||
having (?count=0) | |||
ORDER BY ?person | |||
</sparql> | </sparql> | ||