727
edits
(3 intermediate revisions by the same user not shown) | |||
Line 170: | Line 170: | ||
</sparql> | </sparql> | ||
=== Women's interactions with SAL (Q1 and Q8)=== | === Women's interactions with SAL (Q1 and Q8)=== | ||
Line 247: | Line 214: | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#title:Women's interactions with RAI (Q35 and Q29) | #title:Women's interactions with RAI (Q35 and Q29) | ||
# CAVEAT: this query may overlook a significant number of interactions and should probably not be reference/archived in its current state | |||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | PREFIX bnwds: <https://beyond-notability.wikibase.cloud/entity/statement/> | ||
Line 446: | Line 414: | ||
PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | PREFIX bnpqv: <https://beyond-notability.wikibase.cloud/prop/qualifier/value/> | ||
SELECT distinct ?personLabel ?workLabel ?positionLabel ? | SELECT distinct ?personLabel ?workLabel ?positionLabel ?date_propLabel ?date | ||
?employerLabel ?organisedLabel ?ofLabel ?person | ?employerLabel ?organisedLabel ?ofLabel ?locationLabel ?person | ||
#?s ?position ?of ?work ?employer ?organised | #?s ?position ?of ?work ?employer ?organised ?location ?date_prop | ||
WHERE { | WHERE { | ||
Line 462: | Line 430: | ||
# more about the position | # more about the position | ||
?s ( bnps:P17|bnps:P48|bnps:P105 ) ?position . | ?s ( bnps:P17|bnps:P48|bnps:P105 ) ?position . | ||
# employer / organised by / of (incl free text) | # employer / organised by / of (incl free text). | ||
# for position held, employer>of [ontology day discussion 13/9/23] | # for position held, employer>of [ontology day discussion 13/9/23] | ||
OPTIONAL { ?s bnpq:P18 ?employer .} | OPTIONAL { ?s bnpq:P18 ?employer .} | ||
Line 468: | Line 436: | ||
OPTIONAL { ?s ( bnpq:P78 | bnpq:P66 ) ?of .} | OPTIONAL { ?s ( bnpq:P78 | bnpq:P66 ) ?of .} | ||
optional { ?s bnpq:P2 ?location . } | |||
# dates | # dates with property labels. | ||
optional { | optional { | ||
?s ?pq ?date . | ?s ?pq ?date . | ||
?date_prop wikibase:qualifier ?pq; | |||
? | wikibase:propertyType wikibase:Time . | ||
wikibase:propertyType wikibase:Time | |||
} # /dates | } # /dates | ||
edits