579
edits
Project:SPARQL/examples: Difference between revisions
m
→Lecturers
m (→One woman) |
m (→Lecturers) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 554: | Line 554: | ||
</sparql> | </sparql> | ||
=== Lecturers === | |||
<sparql tryit="1"> | |||
#title:lecturers | |||
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 ?person ?personLabel ?positionLabel | |||
?organisedLabel ?ofLabel | |||
?qual_propLabel ?qualLabel | |||
#?position ?of ?work ?organised ?date_precision ?qual_prop ?date ?qual ?workLabel | |||
?s | |||
WHERE { | |||
?person bnwdt:P3 bnwd:Q3 . # women | |||
# work activities: held position / held position (free text) / employed as | |||
#?person ( bnp:P17|bnp:P48|bnp:P105 ) ?s . | |||
?person ?work_p ?s . # for activity type label | |||
?work wikibase:claim ?work_p . | |||
?s ?bnps ?position . | |||
# freelance and extension lecturing (q701 and q3021) | |||
{ ?s ?bnps bnwd:Q701 . } union { ?s ?bnps bnwd:Q3021 . } | |||
# employer / organised by / of (incl free text). | |||
OPTIONAL { ?s bnpq:P109 ?organised .} | |||
OPTIONAL { ?s ( bnpq:P78 | bnpq:P66 ) ?of .} | |||
# optional { ?s bnpq:P2 ?location . } # do locations separately. | |||
# dates with precision | |||
# optional { | |||
# ?s (bnpqv:P1 | bnpqv:P27 | bnpqv:P28 ) ?pqv. | |||
# ?s ?pqq ?pqv . # just gets the uri but doesnt seem to cause dups | |||
# ?pqv wikibase:timeValue ?date . | |||
# ?pqv wikibase:timePrecision ?date_precision . | |||
# } | |||
# qualifiers | |||
optional { | |||
?s ?pq ?qual . | |||
?qual_prop wikibase:qualifier ?pq . | |||
} # /dates | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,en-gb". } | |||
} # /where | |||
ORDER BY ?person ?s | |||
</sparql> | |||
== Professional Activities and Organisations == | == Professional Activities and Organisations == | ||