579
edits
Project:SPARQL/examples: Difference between revisions
→Dates
(→Dates) |
(→Dates) |
||
| Line 1,403: | Line 1,403: | ||
} | } | ||
ORDER BY ?date | ORDER BY ?date | ||
</sparql> | |||
=== Any main level date for women === | |||
<sparql tryit="1"> | |||
# a query to get all types of main date for women | |||
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/> | |||
SELECT DISTINCT ?person ?personLabel ?date_label ?date ?date_prop_type ?date_prop | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . # women | |||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} | |||
?person ?p ?s . | |||
?date_prop wikibase:claim ?p; | |||
wikibase:statementValue ?psv ; | |||
wikibase:propertyType ?date_prop_type; # property type = wikibase:Time OR wikibase:Edtf | |||
rdfs:label ?date_label. filter(lang(?date_label)="en-gb") . # what kind of date it is | |||
?s ?psv ?wdv . # for the date value | |||
?wdv wikibase:timeValue ?date . #timeValue gets pit and edtf | |||
# ?wdv wikibase:timePrecision ?date_precision . # optional | |||
# nb also possible to filter either/or time/edtf by property type | |||
# filter(?date_prop_type in (wikibase:Edtf, wikibase:Time ) ) . | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } | |||
} | |||
ORDER BY ?personLabel ?date | |||
</sparql> | </sparql> | ||