579
edits
Project:SPARQL/examples: Difference between revisions
→Dates
(→Dates) |
|||
| Line 1,530: | Line 1,530: | ||
ORDER BY ?personLabel ?date | ORDER BY ?personLabel ?date | ||
</sparql> | |||
=== Counting Dates=== | |||
<sparql tryit="1"> | |||
# count distinct dates for women (who have at least one) | |||
# CAVEAT: there may be some discrepancies between dates shown on wiki pages and dates returned by sparql | |||
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 ?person ?personLabel (COUNT(DISTINCT ?date_value) as ?count) | |||
WHERE { | |||
{ # main dates | |||
?person bnwdt:P3 bnwd:Q3 . # women | |||
?person ?p ?s . | |||
?s ?date_prop ?wdv . | |||
?wdv wikibase:timeValue ?date_value . | |||
} # /main dates | |||
UNION | |||
{ # qualifier dates | |||
?person bnwdt:P3 bnwd:Q3 . | |||
?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 | |||
ORDER BY ?count ?person | |||
</sparql> | </sparql> | ||