579
edits
Project:SPARQL/examples: Difference between revisions
→Working with property paths: organisations and locations
No edit summary |
|||
| Line 3,509: | Line 3,509: | ||
</sparql> | </sparql> | ||
=== One woman === | |||
<sparql tryit="1"> | |||
#title:All About a Woman | |||
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 ?propLabel ?spsLabel ?qual_propLabel ?pqsLabel ?link ?s | |||
# ?main_date ?main_precision ?qual_date ?qual_precision | |||
# ?prop ?sps ?pqs ?pq | |||
WHERE | |||
{ | |||
VALUES (?person) {(bnwd:Q569)} # (bnwd:etc) if you want more than one person. or you really really want ?person | |||
?person ?p ?s . | |||
?prop wikibase:claim ?p; | |||
wikibase:statementProperty ?ps; # simple value | |||
wikibase:statementValue ?psv. # full value | |||
# exclude external IDs | |||
# filter not exists { ?prop wikibase:propertyType wikibase:ExternalId . } | |||
?s ?ps ?sps. | |||
# full date via ?psv | |||
OPTIONAL { | |||
?s ?psv ?spsv . | |||
?spsv wikibase:timeValue ?main_date . | |||
?spsv wikibase:timePrecision ?main_precision . | |||
} | |||
# qualifiers. | |||
optional { | |||
?s ?pq ?pqs . | |||
?qual_prop wikibase:qualifier ?pq . | |||
?qual_prop wikibase:qualifierValue ?pqp . | |||
optional { | |||
# full date via ?pqp | |||
?s ?pqp ?qv . | |||
?qv wikibase:timeValue ?qual_date. | |||
?qv wikibase:timePrecision ?qual_precision. | |||
} | |||
} | |||
# direct link to property | |||
BIND (REPLACE(STR(?prop), "^.*/([^/]*)$", "$1") as ?pid). | |||
bind(iri(concat(str(?person), "#", ?pid)) as ?link ) . | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} | |||
order by ?propLabel ?s | |||
</sparql> | |||
===Working with property paths: organisations and locations=== | ===Working with property paths: organisations and locations=== | ||