579
edits
Project:SPARQL/examples: Difference between revisions
→Work
(→Work) |
|||
| Line 455: | Line 455: | ||
} | } | ||
ORDER BY ?inLabel ?personLabel | ORDER BY ?inLabel ?personLabel | ||
</sparql> | |||
== Professional Activities and Organisations == | |||
=== Women's service on committees etc (P102) === | |||
<sparql tryit="1"> | |||
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/> | |||
SELECT distinct ?personLabel ?serviceLabel ?service ?qual_prop_label ?qualLabel ?qual ?person #?s | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . # select women | |||
FILTER NOT EXISTS {?person bnwdt:P4 bnwd:Q12 .} #filter out project team | |||
?person bnp:P102 ?s . # served on P102 | |||
?person ?p ?s . # for claim | |||
?served wikibase:claim ?p; | |||
wikibase:statementProperty ?ps; | |||
wikibase:propertyType ?prop_type. | |||
?s ?ps ?service . # service on what | |||
#qualifiers, if any | |||
optional { | |||
?s ?pq ?qual . | |||
?qual_prop wikibase:qualifier ?pq; | |||
wikibase:propertyType ?prop_type; | |||
rdfs:label ?qual_prop_label . filter(lang(?qual_prop_label)="en-gb") . # what kind of thing | |||
} # /quals | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en-gb, en". } | |||
} | |||
ORDER BY ?personLabel ?s | |||
</sparql> | </sparql> | ||